Thursday, June 26, 2008

Privileges and it's Category in Oracle

In your database if you are a dba then you possibly can do everything in your database like create a new user, create objects in another schema and etc. If you are a normal user then you can't create user or create objects in another schema. All these tasks are maintained by granting privilege to a user. We can define privilege in following ways,

"A privilege is a right to execute a particular type of SQL statement or to access another user's object."

Privilege can be divided into six major category.

1)System Privileges
2)Schema Object Privileges
3)Table Privileges
4)View Privileges
5)Procedure Privileges
6)Type Privileges

No comments:

Post a Comment