|
-
SQL> select s.grantee, r.grantee grantee_through_role
2 from dba_sys_privs s,
3 dba_role_privs r
4 where s.privilege='RESTRICTED SESSION'
5 and r.granted_role (+) = s.grantee;
GRANTEE GRANTEE_THROUGH_ROLE
------------------------------ ------------------------------
DBA COPYMGR
DBA COPYMGR_TMP
DBA MARCIO
DBA ORACLE
DBA SYS
DBA SYSTEM
AURORA$ORB$UNAUTHENTICATED
This last user I do not know.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|