Show_table_role_privileges

Examining Role Table Privileges in Oracle Using role_tab_privs This page delves into an Oracle SQL code snippet that investigates table privileges granted to a specific role. SQL Code 1select owner || '.' || table_name "TABLE" 2, column_name 3, privilege 4, grantable 5from role_tab_privs 6where role like '&role' 7/ …