-- 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
;

-- Roles, owner, table and privileges

SELECT * FROM SYS.role_tab_privs
;

SELECT * FROM SYS.role_tab_privs WHERE role = UPPER('&role_name')
;

-- Session privileges, roles and context

SELECT * FROM SYS.session_privs
;

SELECT * FROM SYS.session_roles
;

SELECT * FROM SYS.session_context
;