Monday, February 23, 2009

System Vs Object Privileges

Difference between system privilege and object privilege is that system privilege is the right to perform specific activities in a database whereas an object privilege is a right to perform activities on a specific object in the database.

Examples of System privileges: CREATE TABLE, CREATE INDEX, CREATE USER, CREATE VIEW...

Examples of Object privileges: SELECT, INSERT, UPDATE, DELETE, COMMENT...

No comments:

Post a Comment