hI ,
How do we check Privileges for all users whether grant privilege is given or not?
I tried to check
select * form all_users
Select * from dict where table_name like '%PRIV%'
SELECT *
FROM all_tab_privs
WHERE table_name in (select object_name from user_objects where object_type = 'PROCEDURE')
I want to check for all users whether we have granted privileges or not.