Query/Check Privileges in Oracle Database
§ --Determine the role privileges
Select* fromrole_tab_privs; -- The object privileges granted to roles in data dictionary views.
Select* fromrole_role_privs; -- Containing the role granted to another role.
Select* fromrole_sys_privs; --Contains the system privileges granted to roles.
§ --Determine the user privileges
Select* fromDBA_tab_privs; -- The object privileges granted to the user.
Select* fromDBA_role_privs; -- The roles granted to the user.
Select* fromDBA_sys_privs; -- The system privileges granted to the user.
§ --View the current user privileges
Select* fromsession_privs;