Object Privileges
-- Get all materialized view read/select privilege for named 
-- user -> READ_ONLY_USER

-- For any table table_name = 'SALES_DETAILS'

SELECT dtp.*
FROM dba_tab_privs dtp
WHERE owner = user      --any user
AND   grantee = 'READ_ONLY_USER'
AND   INSTR(table_name,'MVW') >0;

-- Get role privilege

SELECT drp.* FROM dba_role_privs drp
;

-- Get column level privilege

SELECT dcp.*
FROM dba_col_privs dcp
WHERE owner = 'SYS'      --any user
;


Detail Privilege queries

Oracle registered trademark of Oracle Corporation.

Last Revised On: April 4th, 2014

  400