RE: How to Control Access Privilege in OEM

The user wants to use the GUI interface and particular about the OEM as he has used it in the past experience. I am also checking with Oracle is there any way to restrict the access.

Is there any security risk of giving "SELECT ANY DICTIONARY" to the developer from the DBA perspective?

-Raja.

-----Original Message-----

From: Aragon, Gabriel (GE Commercial Finance) [mailto:gabriel.aragon_at_ge.com]

Sent: Wednesday, June 15, 2005 4:05 PM
To: Nagarajan.Subbiah_at_aetn.com; Oracle-l_at_freelists.org Subject: RE: How to Control Access Privilege in OEM

I am still trying to find out how to do that, but in the meanwhile, if they only require OEM to access session, sql and lock info, why dont you create a couple of customized views for those sys views and grant select access to the user? So, they have what they need and nothing else.

=)
GAP
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Subbiah, Nagarajan
Sent: Martes, 14 de Junio de 2005 02:35 p.m. To: 'Oracle-l_at_freelists.org'
Subject: How to Control Access Privilege in OEM

Is there anyway to control the access privilege of OEM to the selected functionality? One of my developers want to use the OEM for the session, SQL and Lock Information. OEM requires SELECT ANY DICTIONARY privilege which gives lot more information than the developer required and I would like to restrict the other access. We are at Oracle 9i Release 2  

Thanks in Advance.  

Raja
Ph: (212) 210 1461  

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 17 2005 - 12:43:04 CDT