|
Re: roles granted to a role [message #669512 is a reply to message #669511] |
Thu, 26 April 2018 13:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Here's a general way to find what you are searching for:
SQL> col table_name format a23
SQL> col comments format a90
SQL> select table_name, comments from dict where lower(comments) like '%role%' order by 1;
TABLE_NAME COMMENTS
----------------------- ------------------------------------------------------------------------------------------
ALL_COL_PRIVS Grants on columns for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
ALL_COL_PRIVS_RECD Grants on columns for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_PRIVS Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_RECD Grants on objects for which the user, PUBLIC or enabled role is the grantee
COLUMN_PRIVILEGES Grants on columns for which the user is the grantor, grantee, owner, or
an enabled role or PUBLIC is the grantee
DBA_AUDIT_OBJECT Audit trail records for statements concerning objects, specifically: table, cluster, view,
index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback
segment, tablespace, role, user
DBA_ROLES All Roles which exist in the database
DBA_ROLE_PRIVS Roles granted to users and roles
DBA_SCHEDULER_JOB_ROLES All scheduler jobs in the database by database role
DBA_SYS_PRIVS System privileges granted to users and roles
ROLE_ROLE_PRIVS Roles which are granted to roles
ROLE_SYS_PRIVS System privileges granted to roles
ROLE_TAB_PRIVS Table privileges granted to roles
SESSION_ROLES Roles which the user currently has enabled.
TABLE_PRIVILEGES Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
USER_AUDIT_OBJECT Audit trail records for statements concerning objects, specifically: table, cluster, view,
index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback
segment, tablespace, role, user
USER_ROLE_PRIVS Roles granted to current user
Have a closer look at those starting with ROLE.
|
|
|
Re: roles granted to a role [message #669515 is a reply to message #669512] |
Thu, 26 April 2018 14:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
wtolentino
Messages: 404 Registered: March 2005
|
Senior Member |
|
|
thanks so much.
there is a role name R_LPA_EXECUTE that i know was been granted to another role. i tried to use this data dictionary ROLE_ROLE_PRIVS however there was no rows found. i think since the account that i am using can only see what was been granted to it i will not be able to see it. and i do not have access to the dba_ data dictionary view. if i am to build a query and have our dba run it is it the DBA_ROLE_PRIVS that i should be using
for example:
select * from dba_role_privs
where role = 'R_LPA_EXECUTE'
[Updated on: Thu, 26 April 2018 14:08] Report message to a moderator
|
|
|
|
Re: roles granted to a role [message #669517 is a reply to message #669515] |
Thu, 26 April 2018 14:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Solomon Yakobson
Messages: 3280 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
wtolentino wrote on Thu, 26 April 2018 15:04
for example:
select * from dba_role_privs
where role = 'R_LPA_EXECUTE'
There is no column ROLE in DBA_ROLE_PRIVS, so what you posted would have failed.
SY.
|
|
|
Re: roles granted to a role [message #669537 is a reply to message #669517] |
Fri, 27 April 2018 08:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
wtolentino
Messages: 404 Registered: March 2005
|
Senior Member |
|
|
i know that i will not be able to see the roles that were not accessible to my account. if i will request this to the dba:
select * from role_role_privs
where role = 'R_LPA_EXECUTE';
that will give me the info that i am looking for right? it's just that i have to build the query and thee dba will execute it.
thanks.
|
|
|
|
|
|
|