What is system 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 system privilege?
Rating:
System privilege is a privilege or right that allows a user to perform system level activities, such as connecting to a database, creating, altering, dropping, and managing database objects or features. Oracle does not retain the grantor of the system privileges. Therefore, even if a grantee has obtained system privileges from more than one grantor, these can be revoked by anyone with the appropriate privileges.
System privileges are granted using the GRANT statement.
[, { system_privilege | role | ALL PRIVILEGES }]...
TO grantee_clause [IDENTIFIED BY password] [WITH ADMIN OPTION];
Rating:
Was this information helpful?
Other articles
- What are the guidelines for creating a package?
- What is ORACLE_HOME?
- What are the advantages of using packages?
- What is an INSTEAD OF trigger?
- What is the %TYPE attribute?