Oracle Database - Grant

About

Management

List

The grants are stored in view that have the privs suffix (Privileges).

select * from all_objects where object_name like '%PRIV%';

The most important is the table (dba|user)_tab_privs. It shows the privileges of the following type:

  • SEQUENCE
  • PACKAGE
  • USER
  • TABLE
  • VIEW

Direct Indirect

Example:

  • Direct Grant on Table
select * from table_privileges;
  • Through a role:
SELECT 
    owner, 
    table_name,
    PRIVILEGE 
FROM 
    dba_role_privs rp 
    INNER JOIN role_tab_privs rtp ON (rp.granted_role = rtp.role);

Grantee

  • USER Name
  • PUBLIC

Documentation / Reference


Powered by ComboStrap