I am using Oracle 10g and I presently have this kind of setup for my new project.
Expand|Select|Wrap|Line Numbers
- grant WINA$USER to WINA$USRADM with admin option; (where both WINA$USER and WINA$USRADM are roles)
- SQL> select * from dba_role_privs where admin_option ='YES' and grantee like 'WINA$%' order by grantee;
- GRANTEE GRANTED_ROLE ADM DEF
- ------------------------------ ------------------------------ --- ---
- WINA$USRADM WINA$USER YES YES
Expand|Select|Wrap|Line Numbers
- create user C$SETUP identified by password
- grant WINA$USER to C$SETUP
But my dba says that, this kind of option will raise an audit issue and do not grant an admin option. So please advise me for a work around.