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 the STATISTICS_LEVEL parameter?
- What is Flashback Transaction Query?
- What is the trigger restriction on a mutating table?
- What is external authentication?
- What are the development steps for creating a package?