Wed 31 Jan 2007
current user
SQL> desc user_role_privs;
 Name                                     Null?   Type
 —————————————– ——– —————
 Name                                     Null?   Type
 —————————————– ——– —————
 USERNAME                                          VARCHAR2(30)
 GRANTED_ROLE                                      VARCHAR2(30)
 ADMIN_OPTION                                      VARCHAR2(3)
 DEFAULT_ROLE                                      VARCHAR2(3)
 OS_GRANTED                                        VARCHAR2(3)
 GRANTED_ROLE                                      VARCHAR2(30)
 ADMIN_OPTION                                      VARCHAR2(3)
 DEFAULT_ROLE                                      VARCHAR2(3)
 OS_GRANTED                                        VARCHAR2(3)
by DBA user
SQL> desc dba_sys_privs
 Name                                     Null?   Type
 —————————————– ——– —————————
 Name                                     Null?   Type
 —————————————– ——– —————————
 GRANTEE                                  NOT NULL VARCHAR2(30)
 PRIVILEGE                                NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                      VARCHAR2(3)
 PRIVILEGE                                NOT NULL VARCHAR2(40)
 ADMIN_OPTION                                      VARCHAR2(3)
Â
Â
1. sqlplus system/oracle@sox9i
Sqlplus > select privilege from dba_sys_privs where grantee=’OPWORKFLOW’;
Sqlplus > select privilege from dba_sys_privs where grantee=’OPWORKFLOW’;
2. sqlplus opworkflow/opworkflow@sox9i
Sqlplus> select granted_role from user_role_privs;
Sqlplus> select granted_role from user_role_privs;
Leave a Reply
You must be logged in to post a comment.