Oracle System and object 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.
Related Article

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.