Friends ,
I have the follwoing two questions about the Oracle's Role Management ,
1)
Suppose I create a role 'role1' and give the below privileges :
SQL> grant select on scott.dept to role1;
Grant succeeded.
SQL> grant update on scott.dept to role2;
Grant succeeded.
Now , would anybody please tell me , using which view I can see these privileges or from which views , I can see the privileges which contains 'role1' /'role2'? I try to use the views like , dba_role_privs, role_role_privs, dba_sys_privs, role_sys_privs, role_tab_privs BUT I cannot find .
2)
I need an example How I can manage a ROLE externally ( by using O/S authentication ) . I set OS_ROLES=TRUE , but cannnot connected to the databaes . It shows following error :
SQL> grant role1 to aaron;
grant role1 to aaron
*
ERROR at line 1:
ORA-01956: invalid command when OS_ROLES are being used
Would anybody plz give me a proper documentation from where I can get a proper example ?
I am using LINUX O/S .
Waiting for kind reply ... ...
Edited by: shipon_97 on Dec 2, 2009 6:26 PM