Complete Set of Oracle Permissions

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.