Oracle system permission Classification

Cluster permission

Reference
Create Cluster
Create, change, and delete clusters in your own solution
Create any cluster
Create a group set in any solution
Alter any cluster
Change a cluster in any solution
Drop any cluster
Delete a cluster in any solution

Database Permissions

Reference
Alter Database
Run the alter database statement to change the database configuration.
Alter System
Run the alter System statement to change the system initialization parameters.
Audit System
Run the audit system and noaudit system statements to audit SQL statements.
Audit any
Run the audit and noaudit statements to audit the objects in any solution.

Index permission

Reference
Create any index
Create an index in any solution
Note: you do not have the create index permission. the create table permission includes the create index permission.
Alter any index
Change indexes in any solution
Drop any index
Delete indexes in any solution

Process permission

Reference
Create procedure
Create, change, or delete processes, functions, and packages in your own solution
Create any procedure
Create processes, functions, and packages in any solution
Alter any procedure
Change processes, functions, and packages in any scenario
Drop any procedure
Delete a process, function, or package in any solution
Execute any procedure
Execute or reference the process in any solution

Profile permission

Reference
Create Profile
Create Profile
Alter Profile
Change Profile
Drop Profile
Delete profile

Role Permissions

Reference
Create role
Create a role
Alter any role
Change any role
Drop any role
Delete any role
Grant any role
Assign any role to another role or user
Note: you do not have the corresponding revoke any role permission.

Rollback segment permission

Reference
Create rollback segment
Create rollback segments
Note: you do not have the permission to revoke segments.
Alter rollback segment
Change rollback segment
Drop rollback segment
Delete rollback segments

 

Sequential permission

Reference
Create seqlence
Create, change, delete, and select sequences in your own solution
Create any sequence
Create a sequence in any solution
Alter any sequence
Change the sequence in any scheme
Drop any sequence
Delete sequence in any solution
Select any sequence
Select from any sequence in any scheme

Session permission

Reference
Create session
Create a session and log on to the database.
Alter session
Run the alter session Statement to change the session attributes.
Alter Resource Cost
Change the computing resource consumption method in the Summary File
Restricted session
Connect to data when the database is in restricted session Mode

 

Synonym permission

Reference
Create Synonym
Create and delete synonyms in your own solution
Create any synonym
Create a special synonym in any solution
Create public Synonym
Create a public Synonym
Drop any synonym
Delete synonyms in any solution
Drop public Synonym
Delete public synonyms

Table Permissions

Reference
Create Table
Create, modify, and delete tables in your own solution
Create any table
Create a table in any solution
Alter any-table
Change tables in any solution
Drop any table
Delete a table in any solution
Comment any table
Add comments to any table, view, or column in any solution
Select any table
Select records from any table in any scheme
Insert any table
Insert a new record to any table in any scheme
Update any table
Change records in any table in any scheme
Delete any table
Delete records from any table in any solution
Lock any table
Lock any table in any scheme
Flashback any table
Allows the use of the AS of clause to execute a flash-back query of an SQL statement on tables and views in any solution.

Tablespace permission

Reference
Create tablespace
Create a tablespace
Alter tablespace
Change tablespace
Drop tablespace
Delete a tablespace, including a table, index, and tablespace cluster.
Manage tablespace
Manage tablespaces so that the tablespaces are in the online, offline, begin backup, and end backup statuses.
Unlimited tablespace
Use tablespaces without quota
Note: You can only grant unlimited tablespace to an account, but not a role.

User Permissions

Reference
Create user
Create user
Alter user
Change User
Become user
When fully loaded, become another user
Drop user
Delete a user

View permission

Reference
Create View
Create, modify, and delete views in your own solution
Create any view
Create a view in any solution
Drop any view
Delete a view in any solution
Comment any table
Add comments to any table, view, or column in any solution
Flashback any table
Allows the use of the AS of clause to execute a flash-back query of an SQL statement on tables and views in any solution.

 

Trigger permission

Reference
Create trigger
Create, change, and delete triggers in your own solution
Create any trigger
Create a trigger in any solution
Alter any trigger
Change the trigger in any solution
Drop any trigger
Delete a trigger in any solution
Administer database trigger
Allows you to create an on Database trigger. Before creating an on Database trigger, you must have the create trigger or create any trigger permission.

Dedicated Permissions

Reference
Sysoper
(System Operator permission)
Startup
Shutdown
Alter database Mount/Open
Alter Database Backup controlfile
Alter database begin/end backup
Alter database archivelog
Recover Database
Restricted session
Create spfile/pfile
Sysdba
(System administrator privilege)
All sysoper permissions with the with admin option clause
Create Database
Recover database

Other Permissions

Reference
Analyze any
Execute the analyze Statement on any table, cluster, or index in any solution.
Grant any Object Privilege
Grant the object permission on any object in any scheme
Note: No corresponding revoke any Object Privilege
Grant any privilege
Grant any system Permissions
Note: There is no corresponding revoke any privilege
Select any dictionary
Allows you to select data dictionary tables owned by sys users.