What is privilege and types of privilege in Oracle

In this article, we will discuss on the privilege in Oracle. The privilege is a user privilege and assigned to a users and roles. The all privilege use for connect to the database and connect a table. The privilege is a right to execute a particular type of SQL statement or to access another user's object.

Two types of privilege in Oracle

System Privilege Object Privilege

1. System Privilege: The system privilege means enables users to perform particular actions in the database. We will use DDL command in the system privilege and this privilege is effect on the system.

Foe Example: Create table, sysdba, Create view etc.

The SYSTEM_PRIVILEGE_MAP parameter is show all system privilege name and property. The system_privilege_map parameter means describes privilege type codes.

SQL> DESC SYSTEM_PRIVILEGE_MAP

Output:

Privilege: The privilege means numeric privilege type code.

Name: The name means name of the type of privilege.

Property: The property means flag of the privilege.

SQL> SELECT * FROM SYSTEM_PRIVILEGE_MAP;

Output:

2. Object Privilege: The object privilege means enables users to access and manipulate a specific object. We will use DML command in the system privilege and this privilege is effect on the parameter object.

For Example: Alter Command, Select Command, Delete Command etc.

View the original article here