Roles

Query to get the output for object privileges, roles, system privileges with details

Please use the below query to get the output.   set echo on; SELECT COUNT(*) AS object_priv_count FROM dba_tab_privs WHERE grantee = ‘A’; set echo on; SELECT COUNT(*) AS role_grant_count…