This content has been marked as final. Show 6 replies
You don't have to crate a db user for that. Check http://www.oracledistilled.com/grid-control/privileges-roles-and-users-in-oracle-enterprise-manager-11gr1-grid-control/ how you can create an additional (super) Admin user in EM.
Most easy way is to use the Create Like button.
we even have emcli verbs to create users and roles in a scripted fashion or in bulk.
Thanx for the tip using emcli. We have an automated system that let's us know when a new user is requested for our OMS. I am looking to let that message be the trigger for an additional automated process for the user creation.
One thing I noticed is that the emcli command creates the application user but not the database user. It also has the incorrect database profile. Perhaps I am missing something?
Here is the command I used:
emcli create_user -name=TEST123 -desc="Test using EMCLI" -privilege="VIEW_ANY_TARGET" -expire="true" -password="XXXXXXXXXX" -email="firstname.lastname@example.org" -profile="XXX_PWD_AGING" -roles="PUBLIC" -type="DB_EXTERNAL_USER"
And here is my output from both emcli and sqlplus:
User "TEST123" created successfully
SQL> select * from dba_users where username = 'TEST123';
no rows selected
Perhaps I am missing something?
You are missing the point that no additional database user is created.1 person found this helpful
What type="DB_EXTERNAL_USER" means can be found in the EM Admin Guide chapter Enterprise Manager Security
Sorry, my mistake. A repository database user is created. Never realised that.
Edited by: EricvdS on 21-sep-2012 11:06
Leave off the -type="DB_EXTERNAL_USER" and your user will be created as a repository authenticated (EM_USER) user (which will be a database user).
Type of User. The Default value of this parameter is EM_USER. Possible values for this parameter are:
Awesome save. Thanx for the insight.