What is object privilege?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is object privilege?
Rating:
Object privilege is a privilege or right to perform a particular action on specific schema objects, such as tables, views, sequences, procedures, programmer-defined functions, and libraries. Object privileges can be obtained from more than one grantor. They can only be revoked by their grantors. To completely revoke object privileges from an account, all the grantors must revoke them.
Object privileges are granted using the GRANT statement.
[, { object_privilege | ALL [PRIVILEGES] } [( column [, column]... )]]...
on_object_clause
TO grantee_clause
[WITH GRANT OPTION] [WITH HIERARCHY OPTION];
Rating:
Was this information helpful?
Other articles
- What is an instance failure?
- Tip on upgrading the database.
- What is DECODE function?
- What are the different states of a constraint?
- THE ORACLE 10g ARCHITECTURE