Workaround for using admin option [message #243364] |
Thu, 07 June 2007 02:06 |
rajeshdbabu
Messages: 3 Registered: June 2007
|
Junior Member |
|
|
Hi Experts,
I am using Oracle 10g and I presently have this kind of setup for my new project.
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
In my vb code I use the follwing code to create and grant role for the new users:
create user C$SETUP identified by password
grant WINA$USER to C$SETUP
In order for User A (who is assigned WINA$USRADM role) to be able to "grant WINA$USER" to other users, I have given "grant WINA$USER to WINA$USRADM with admin option" in order for the VB code to work.
But my dba says that, this kind of option will raise an audit issue and not to grant an admin option. Can someone please advise me for a work around.
Appreciate your kind help on this matter urgently. Thank you.
|
|
|
|
|
|