WebIs it possible to create a DBA_ROLE_ROLE_PRIVS table that lists all of the ROLE-to-ROLE relationships across the entire database? My understanding is that the ROLE_ROLE_PRIVS table only shows data for the individual schema that queries it. I am looking for a complete listing that is not tied to an underlying account. Most of the other SYS ... WebMar 6, 2016 · Using below query you can find out users having dba roles in Oracle : SQL> select * from dba_role_privs where granted_role='DBA'; GRANTEE GRANTED_ROLE ADM DEF --------- ------------ --- --- SYS DBA YES YES SYSTEM DBA YES YES Share Improve this answer Follow edited Jul 16, 2024 at 17:39 RDFozz 11.5k 4 22 37 answered Jul 16, 2024 at 17:09
database - Oracle: Grants for select from …
WebDec 17, 2013 · Sorted by: 7. You can find this information in the DBA_* views in Oracle. To find all roles in the database: select * from dba_roles. To find what roles a particular user has: select * from dba_role_privs where grantee=. Share. Improve this answer. WebJul 16, 2024 · DEFAULT_ROLE: Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO) Using below query you can find users having DBA privileges SQL> select * from dba_role_privs where granted_role='DBA'; GRANTEE GRANTED_ROLE ADM DEF --------- ------------ --- --- SYS DBA YES YES SYSTEM DBA YES YES randi motors osaka
DBA_ROLE_PRIVS - Oracle Help Center
WebIn addition to VAV's answer, The first one was most useful in my environment select * from USER_ROLE_PRIVS where USERNAME='SAMPLE'; select * from USER_TAB_PRIVS. … WebApr 14, 2014 · SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE='ROLE_NAME'; DBA_TAB_PRIVS describes all object grants in the database. Or to get the grants for all the roles, you can use below query. SELECT grantee role_name,table_name,privilege FROM dba_tab_privs dtp,dba_roles dr WHERE dtp.grantee=dr.role ORDER BY … WebThen I thought of creating this view: create or replace view all_role_privs as select * from dba_role_privs where granted_role in ( select granted_role from user_roles where admin_option = 'YES' ) / where user_roles is a recursive view like user_role_hierarchy but augmented to show the admin_option column as well. dr khafaji gold coast