Enterprise Manager Generic (MOSC)

MOSC Banner

Specific Permissions to Allow Helpdesk Analysts to Perform an Alter User with OEM 10g?

edited Oct 6, 2009 9:35AM in Enterprise Manager Generic (MOSC) 1 commentAnswered
We would like to have our helpdesk analysts be able to use OEM 10g to perform 'alter user' against specified users.  We have helpdesk analyst user ids set up with this capability & they appear to work as intended.  However, I would like to tighten up the permissions on these accounts, they  are defined as follows:

GRANT ALTER USER TO "HELPDESK_ANALYST"
GRANT CREATE SESSION TO "HELPDESK_ANALYST"
GRANT SELECT ANY DICTIONARY TO "HELPDESK_ANALYST"

Straightforward enough.  However, I would prefer not to use the 'select any dictionary' system privilege & specify specific tables needing access to.   I've found Metalink discussions on this topic for 9i OEM, but not 10g.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center