Oracle Database - Grant

Card Puncher Data Processing

About

apps/search/search.jsp

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





Discover More
Card Puncher Data Processing
Oracle Database - Package

Oracle Database - Package
Card Puncher Data Processing
Oracle Database - Table

A table name must follow the naming convention of database object. Add DataType Create Table ...



Share this page:
Follow us:
Task Runner