You can use the default userid that OEM creates for repository ownership (SYSMAN) and call it a day. OR Look at the privileges that SYSMAN has and compare it to the userid you created. I would suspect that some system privileges would have to be granted directly to the userid instead of via a role. Try granting the simple privs first, like CREATE SESSION, ALTER USER, CREATE TABLE, etc. Remember, privileges inherited via a role are not active while executing a stored procedure. DBA is a role.
RWB "oraora oraora" <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 03:14:01 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: guys, i am on 8.1.6/w2k. i tried to create a new server management repository using Enterprise Manager configuration assistant.this is first time i am going to use EM on this machine.but when i gave a usename/pwd during repository login information....i got the error : SELECTED USER LACKS ONE OR MORE OF THE PRIVILEGES OR ROLES REQUIRED TO CREATE AND SUPPORT A MANAGEMENT SERVER REPOSITORY. i have granted dba,sysdba,sysoper privs to that user. what priv/role should be granted to create/support a management server repository ? kindly let me know guys. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).