System Privileges
System privileges allow users to perform particular database operations or groups of database operations.
Oracle provides more than 100 separate and distinct system privileges. Many have different variations based on exactly what the user needs to be able to do.
The privileges have three basic types of classifications: systemwide operations, object management operations in a user's own schema, and object management operations in any user's schema.
Systemwide operations include the capability to create a session (CREATE SESSION privilege) or to create tablespaces (CREATE TABLESPACE privilege). Only a database administrator or someone who has that role can grant systemwide operation privileges.
Schema object management operations ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
