Full 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.

From: http://blog.chinaunix.net/u/21280/showart_441908.html

1. Permission is the user's power to execute a function. In Oracle, permissions are divided into system permissions and entity permissions based on different system management methods. System permission refers to whether authorized users can connect to the database and perform system operations in the database. The entity permission refers to the user's permissions on the specific schema object. This may be a bit fuzzy. For example, the Select any table is a system permission, which indicates that any table can be viewed. Select on Table1 is the object permission, indicating the query permission for table 1.

2. See the table above.

Iii. Use of system permission authorization commands
Syntax:
Grant permission name to user | role | public
Among them, public indicates to grant permissions to all users in the database
For example, run the following command to grant the create table permission to user1:
SQL> grant CREATE TABLE to user1;
The with admin option can also be added to the authorization statement, indicating that the authorized user can grant the permission to other users, for example:
SQL> grant CREATE TABLE, create view to user1, user2 with admin option;
To understand the system permissions of users, You can query the data dictionaries user_sys_privs and role_sys_privs.
To revoke permissions, use the revoke command, for example:
SQL> revoke CREATE TABLE from user1;

Iv. Object permission management
Object permission refers to the operation permissions of a user on a specific schema object.
1. Object permission Classification
Different object types have different object permissions, as shown in the following table.

2. commands for granting object permissions

Syntax:
Grant object permission name | all to user | role | public
All indicates all object permissions.
For example:
SQL> grant select on books_quthors to user1;
The following statement is used to query the table's object permission authorization information:
SQL> select * From user_tab_prives
To revoke object permissions, use revoke. The syntax is as follows:
Revoke object permission name | all on Object Name from user name | role name | public.

 

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.