Dba_role_privs
dba_role_privs: List Oracle Roles Granted to a User
Jan 4, 2024 / · 10 min read · Privileges User dba_role_privs user_role_privs role_role_privs role_sys_privs session_roles ·dba_role_privs: List Oracle Roles Granted to a User Purpose Which roles does an Oracle user hold, and can that user pass them on to others? The view DBA_ROLE_PRIVS answers both questions. It describes the roles granted to all users and roles in the database. One row is one grant. The query below filters that view for …
Read MoreOracle Table Privileges Granted to a Role via role_tab_privs
Jan 4, 2024 / · 11 min read · role privileges show_table_role_privileges oracle role_tab_privs Oracle DBA Security Audit Data Dictionary Oracle Administration dba_roles dba_role_privs ·Oracle Table Privileges Granted to a Role via role_tab_privs Purpose ROLE_TAB_PRIVS lists the object privileges granted to roles — every table, view, and sequence grant, the precise privilege type, and whether the right covers the entire object or is scoped to a single column. Oracle's reference notes that "Information …
Read MoreOracle DBA SQL Scripts and Database Commands
Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …
Read More