Hi Tom,



I need to remove all access on a particular table my_data , as part db object clean up ?

Hence I have revoked access listed in the dba_tab_privs data dictionary.

SELECT * FROM dba_tab_privs WHERE owner = 'TEST' AND table_name = 'MY_DATA' ;

but, the problem is other users(Non - DBA, users not have select any table priv) still have access on the above table.

Can you please help on the below question ?

Thank You.

select * from dba_sys_privs
where  privilege = 'SELECT ANY TABLE';

select * from DBA_ROLE_PRIVS
where  granted_role in (
  select grantee from dba_sys_privs
  where  privilege = 'SELECT ANY TABLE'
);