Home > Grid > Creating a view only user in Enterprise Manager grid control

Creating a view only user in Enterprise Manager grid control

If you need to give database monitoring access to some grid control users.


SQL> connect / as sysdba

SQL> create user grid_view identified by xxx

default tablespace users temporary tablespace temp;

SQL> grant create session, oem_monitor to grid_view;

1. Logon to Grid Control as a super admin user (SYSMAN or equivalent)
2. Click on the links: Setup -> Administrators -> Click on Create
3. Remove the ‘PUBLIC ROLE’ that is listed by default
4. Under Create Administrator: System Privileges select ‘VIEW ANY TARGET’.
5. Under Create Administrator: Targets, choose all the targets this new admin should be able to view
6. Under Create Administrator: Target Privileges , BATCH ASSIGN Choose ‘View’
7. Click Apply.

Login as this new administrator user you created and set grid_view as the username for the database target in preferred credentials.

Reference: metalink note 377310.1

Advertisements
Categories: Grid
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: