Oracle roles

[rajeshdbabu]

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

create user C$SETUP identified by password
grant WINA$USER to C$SETUP

(to create and grant role for the new users.)

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.

[debasisdas]

I think u had already posted this question earlier on , and that has already been replied and was waiting your response.

and so far as audit issue is concerned it differs from organisation to organisation and your DBA is supposed to know more of which i have to idea.

so its better to follow his/her advice.