Specific Permissions to Allow Helpdesk Analysts to Perform an Alter User with OEM 10g?
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.