Oracle System Permissions

 

Alter any cluster: modify the permissions of any cluster

 

Alter any index

 

Alter any role Modify permissions of any role

 

Alter any sequence

 

Alter any snapshot

 

Alter any table

 

Alter any trigger

 

Alter cluster Modify permissions on clusters

 

Alter database: modify database Permissions

 

Alter procedure: modify stored procedure Permissions

 

Alter profile: Permission to modify the resource limit table

 

Alter resource cost

 

Alter rollback segment: Modify rollback segment Permissions

 

Alter sequence

 

Alter session modify Database session Permissions

 

Alter sytem: modify the permissions set by the database server

 

Alter table Modify table Permissions

 

Alter tablespace: Permission to modify tablespaces

 

Alter user: Modify user permissions

 

Analyze uses the analyze command to analyze any tables, indexes, and clusters in the database.

 

Audit any sets audit options for any database objects

 

Audit system allows system Operation audit

 

Backup any table

 

Become user permission for switching user status

 

Commit any table: table submission permission

 

Create any cluster: Permission to create a cluster for any user

 

Create any index is used to create an index for any user.

 

Create any procedure: Permission to create a stored procedure for any user

 

Create any sequence permission to create a sequence for any user

 

Create any snapshot: Permission to create snapshots for any user

 

Create any synonym permission to create a synonym for any user

 

Create any table: Permission to create a table for any user

 

Create any trigger: Permission to create a trigger for any user

 

Create any view: Permission to create a view for any user

 

Create cluster: Permission to create clusters for users

 

Create database link permissions created for users

 

Create procedure permission to create a stored procedure for users

 

Create profile: Create resource limit table Permissions

 

Create public database link: Permission to create a public database link

 

Create public Synonym

 

Create role: Permission to create a role

 

Create rollback segment permission for creating rollback segments

 

Create session

 

Create sequence: Permission to create sequences for users

 

Create snapshot: Permission to create snapshots for users

 

Create synonym: Permission to create a synonym for a user

 

Create Table: Permission to create tables for users

 

Create tablespace permission for creating a tablespace

 

Create user: Create User Permissions

 

Create view permission for creating a view

 

Delete any table: Permission to delete any table row

 

Delete any view permission to delete any View row

 

Delete snapshot: Delete the row permission of the snapshot.

 

The Delete table permission is used to delete table rows.

 

Delete view is the permission to delete view rows.

 

Drop any cluster permission to delete any cluster

 

Drop any index permission to delete any index

 

Drop any procedure permission to delete any stored procedure

 

Drop any role

 

Drop any sequence: Permission to delete any sequence

 

Drop any snapshot permission to delete any snapshot

 

Drop any synonym permission to delete any synonymous name

 

Drop any table permission to delete any table

 

Drop any trigger permission to delete any trigger

 

Drop any view permission to delete any view

 

Drop profile: Permission to delete a Resource Restriction table

 

Drop public cluster permission to delete public Clusters

 

Drop public database link: Permission to delete a public Data link

 

Drop public synonym

 

Drop rollback segment permission to delete rollback segments

 

Drop tablespace permission to delete a tablespace

 

Drop user: delete user Permissions

 

Execute any procedure permission to execute any stored procedure

 

Execute function

 

Execute package: permission to run the Storage package

 

Execute procedure

 

Force any transaction manages the output permissions of uncommitted arbitrary transactions

 

Force transaction manages the output permissions of uncommitted user transactions

 

Grant any privilege grant privileges to any system

 

Grant any role grant permissions to any role

 

Index table: Permission to add an index to a table

 

Insert any table insert row permission to any table

 

Insert snapshot

 

Insert table permission to insert rows into a user table

 

Insert view permission to insert rows into user view

 

Lock any table to lock any table

 

Manager tablespace Management (Backup availability) tablespace permission

 

References table reference table Permissions

 

Restricted session permission for creating a limited database session

 

Select any sequence permission to use any sequence

 

Select any table permission

 

Select snapshot permission to use snapshots

 

Select sequence permission to use user sequence

 

Select table User table permission

 

Select view permission

 

Unlimited tablespace does not limit the table space size

 

Update any table modify the row permissions of any table

 

Update snapshot: Modify the row permissions of a snapshot.

 

Update table: Modify row permissions in user table

 

Update view: Modify the row permissions in the view.