Today when talking to one of my Colleague, He had little bit doubts about oracle privileges.

Although I explained him the concept, I did a little research on it and find out following bits about it.

A privilege is a right to execute an SQL statement (DDL,DML & DCL) or to access another user’s object. Number of privileges in oracle is fixed.

There are two types of privileges:

1. system privileges
2. object privileges.

System Privileges
I didn’t find any cut clear defination for it. But we can say that all the privileges that are related Creation of a object and the privileges that are related to management database system can be categorize into this category.

Example: CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE INDEX, CREATE PROCEDURE, SYSDBA, SYSOPER …….

Object Privileges
Any priviledges that is used in manipulation of data in a object can be categorize into this category.
Example: SELECT, INSERT, UPDATE, DELETE, EXECUTE, READ, WRITE …….