Dba_roles

Find an Oracle role using the view dba_roles This page explores an Oracle SQL code snippet that retrieves information about database roles based on user-provided search criteria. SQL Code 1select * 2from dba_roles 3where role like '&role' 4/ Purpose: This code retrieves information about a specific database role, based …

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 …