Create an OEM Administrator with Limited Targets (OEM 12C)

Posted: July 14, 2015 in Uncategorized
Tags:

Good Afternoon, Oracle Fans!

I was asked by my customer to create an OEM user that their development team and management could use to get a bird’s eye view of performance on the database. What I didn’t want to do was show them all of the targets I can see because it includes the entire Exadata Stack. I found a great article from a few years ago that helped me find what I needed. http://dbastreet.com/blog/?p=395   I have modernized it for version 12C. Here goes!!

1) As SYSMAN, Cick on Setup–> Security –> Administrators

Blog_Post1

2) From the Administrators page, click create.

BlogOEM2

3) Enter all the standard info for creating your administrator on the Create Administrator: Properties page. Click Next

Blog_OEM3

4) Remove the PUBLIC role from the default roles list. Click next.

OEM_blog4

5) From the Target Privileges page, click on Connect to Any Viewable Target.

OEM_Blog5

6) This is the important Part: At the bottom of the Target Privileges Page, add the targets you want the Administrator to be able to view: Click on ADD

OEM_Blog6

Choose your targets and click SELECT.

OEM_BLOG7

There are other privilege options you can grant to the user but my customer only needs view target. Click Next.

Click REVIEW:

Review your choices and…

Click FINISH:

OEM_blog8

At this point the user can view all the targets you granted to the administrator. If you desire the administrator the ability to connect to the target databases, you will need to create a database user with the needed grants/privileges to do so.

Thanks for reading!

Jason

Advertisements

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