Tuesday, April 1, 2008

Connect to EM though normal user

Use the Database Login page to log in to the current database. You can use the Database Login page to enter the Username and Password fields and to select the type of user and its associated privileges to use to log in (Normal, SYSOPER, SYSDBA).

Select Set as Preferred Credential to save the database login information to the Management Repository. For more information, see About Preferred Credentials.

If Normal role preferred credentials are set for a database and a page requiring a login is selected, you will be automatically logged in using the preferred credentials and sent directly to the selected page, bypassing the login page. If the connection attempt using the preferred credentials fails, the login page will appear.

If you choose to log out of the database, you can optionally choose to reconnect as a different user. If you choose this option, the login page will appear after you logout. After logging back in (presumably as a different user), you will return to the page from which you chose to logout. Insufficient Privilege Alert

To use any DBA management functionality as a non-DBA user, you must have the appropriate privileges. A DBA user will already have the appropriate privileges to manage the database.

You can change the privileges for a non-DBA user in Enterprise Manager by choosing Setup on the Database Home page and adding the privileges for a user using the Administrators page. For more information about changing the privileges for a user, see the online help on the Administrators page.

For version 7.x databases: The SELECT_CATALOG_ROLE must be created to allow non-DBA users to perform DBA functions. By running script sc_role.sql this role can be created. This script will have to be run as SYS.

For version 8.x databases: You must have been granted the SELECT_CATALOG_ROLE. To create, edit, or drop objects outside of your schema, you must have been granted the DBA role or the appropriate privileges for the object. Note: The SELECT_CATALOG_ROLE is only available for Oracle8.x databases.

For version 9.x, 10.x and later databases:
You must be granted the Select Any Dictionary privilege. Ask the System Administrator or Super Administrator to grant you this role.

Simply on 9.x later database issue the following,

SQL>GRANT SELECT ANY DICTIONARY TO user_name_that_will_use_em;

For any newly created user if you want to give him minimum privilege to connect through EM and see some reports using that user then your command will be simply,

SQL> grant create session, select any dictionary to arju_em identified by a;
Grant succeeded.

With this command a new user ARJU_EM will be created and he will able to connect to EM and will see various reports through EM.

Related Documents
How to get port number list of EM and isqlplus
How to Notify or send email Event in Oracle from EM

No comments:

Post a Comment