Oracle user permission explanation

Source: Internet
Author: User
Tags directory create

Paste the Excel file as follows >>>>>>>
---------------------
| Permission Definition
---------------------
| Level 1 permission | grant level 1 permissions to other users
| Level 2 permission | oracle internal file management level permission
| Level 3 permission | session, role, user-level permission
| Level 4 permission | table space level permission
| Level 5 permissions | database operation level Permissions
| Level 6 permission | any table operation permission
| Level 7 permission | only the permission to operate on tables in the current tablespace
---------------------

| Permission Name Description
| First-level permission grant any object privilege grant permissions on ANY OBJECT
Grant any privilege grant privileges to ANY system
Grant any role to authorize a ROLE

| Level-2 permission administer any SQL tuning set manages ANY SQL adjustment sets
Administer database trigger permission to manage DATABASE Triggers
Administer resource manager resource management
Administer SQL tuning set manages SQL adjustment sets
MANAGE ANY FILE GROUP
MANAGE ANY QUEUE
Manage file group manage file groups
Manage scheduler permission
Manage tablespace permission for table space management

| Three-level permission: CREATE SESSION
CREATE USER
CREATE ROLE
Alter session modify SESSION Permissions
Alter system: modify Database Server Settings
ALTER USER
Alter any role: Modify ROLE Permissions
Drop user: delete USER Permissions
Drop any role delete permissions of ANY ROLE

| Level-4 permission: unlimited tablespace does not limit the table space size (the default permission is granted after a new user is added, even if the new user belongs to the DBA, unless other permissions are specified, otherwise, only the default permission is granted)
Create tablespace permission for creating a TABLESPACE
Alter tablespace: Permission to modify tablespaces
Drop tablespace permission to delete any TABLESPACE

| Level 5 permission: create database link: Permission to CREATE a DATABASE connection
Alter database: modify DATABASE Permissions
CREATE PUBLIC DATABASE LINK
Drop public database link Delete public database connections
Import full database execute database import role
Export full database export database role

| Level 6 permission: comment any table: permission to submit ANY TABLE
Delete any table: Permission to DELETE ANY TABLE
Insert any table insert record permission to ANY TABLE
Backup any table backup table permission
CREATE ANY CLUSTER
Create any context: Permission to CREATE ANY CONTEXT
Create any dimension: modify the permissions of ANY DIMENSION
Create any directory create dictionary
CREATE ANY EVALUATION CONTEXT CREATE CONTEXT
Create any index: Permission to CREATE an INDEX
Create any indextype: Permission to create any index type
CREATE ANY JOB
Create any library permission to CREATE ANY LIBRARY
Create any materialized view create any object VIEW
CREATE ANY OPERATOR CREATE OPERATOR
Create any outline create any execution plan
Create any procedure permission for creating a stored PROCEDURE
Create any rule create any rules
CREATE ANY RULE SET
Create any sequence permission to CREATE ANY SEQUENCE
Create any SQL profile create any SQL configuration file
Create any synonym permission to CREATE ANY SYNONYM
Create any table: Permission to CREATE ANY TABLE
Create any trigger permission to CREATE ANY TRIGGER
Create any type permission
Create any view permission
Alter any library Modify permissions of ANY LIBRARY
Alter any cluster: modify the permissions of ANY CLUSTER
Alter any dimension: modify the permissions of ANY DIMENSION
Alter any evaluation context modify ANY CONTEXT
ALTER ANY INDEX
ALTER ANY INDEXTYPE
Alter any materialized view modify ANY object VIEW
Alter any outline modify ANY fixed execution plan
Alter any procedure modify the permissions of ANY stored PROCEDURE
Alter any rule: modify the permissions of any rule.
ALTER ANY RULE SET
ALTER ANY SEQUENCE
Alter any SQL profile modify ANY SQL configuration file
Alter any table: modify the permissions of ANY TABLE
Alter any trigger: modify the permissions of ANY TRIGGER
Alter any type: Modify permissions of ANY TYPE
Drop any cluster permission to delete ANY CLUSTER
Drop any context delete ANY question
Drop any dimension: Permission to delete ANY DIMENSION
Drop any directory Delete dictionary
Drop any evaluation context delete ANY CONTEXT
Drop any index delete ANY INDEX
Drop any indextype delete ANY index type
DROP ANY LIBRARY
Drop any materialized view delete ANY object VIEW
Drop any operator delete ANY operators
Drop any outline delete ANY fixed execution plan
Drop any procedure: Permission to delete ANY stored PROCEDURE
Drop any rule: Permission to delete ANY RULE
Drop any rule set delete ANY RULE SET
Drop any sequence: Permission to delete ANY SEQUENCE
Drop any SQL profile delete ANY SQL configuration files
Drop any synonym permission to delete ANY SYNONYM
Drop any table: Permission to delete ANY TABLE
Drop any trigger: Permission to delete ANY TRIGGER
Drop any type: delete permissions of ANY TYPE
Drop any view permission to delete a VIEW
Enqueue any queue permission to add messages to all queues
Execute any class to EXECUTE ANY CLASS
EXECUTE ANY EVALUATION CONTEXT EXECUTE ANY CONTEXT
Execute any indextype: Permission to execute any index type
Execute any library execution LIBRARY
Execute any operator execution OPERATOR
Execute any procedure permission to execute any stored PROCEDURE
Execute any program to EXECUTE ANY PROGRAM
Execute any rule to execute any rules
Execute any rule set to EXECUTE ANY RULE SET
EXECUTE ANY TYPE
Update any table update permission for ANY TABLE
Dequeue any queue can send the message QUEUE permissions to all queues
SELECT ANY SEQUENCE
Select any table query permission for ANY TABLE
Select any transaction query ANY TRANSACTION
Flashback any table flash back to ANY TABLE
Force any transaction manages the output permissions of uncommitted arbitrary transactions
Analyze any use the analyze command to analyze any tables, indexes, and clusters in the database
Audit any sets AUDIT options for ANY database objects
READ ANY FILE GROUP
Lock any table lock permissions for ANY TABLE
MERGE ANY VIEW MERGE VIEW
Debug any procedure debug any program

| Level 7 permission: create cluster: CLUSTER creation permission
Create dimension: Permission to CREATE a DIMENSION
CREATE EVALUATION CONTEXT CREATE CONTEXT
Create external job create any EXTERNAL task
Create indextype create index type
CREATE JOB
Create library permission
Create materialized view create object VIEW
Create operator defines a new OPERATOR
Create procedure permission for creating a stored PROCEDURE
Create profile: CREATE resource limit table Permissions
Create public synonym create public synonyms
Create rollback segment create rollback segments
CREATE RULE
Create rule set: Permission to CREATE a RULE SET
Create sequence permission for SEQUENCE Creation
CREATE SYNONYM
Create table permission
Create trigger permission to CREATE a TRIGGER
CREATE TYPE
Create view permission for creating a VIEW
Alter profile: Permission to modify the resource limit table
Alter resource cost: Set RESOURCE overhead Permissions
Alter rollback segment modify rollback segment permission
Drop profile: Permission to delete a Resource Restriction table
Audit system allows SYSTEM Operation AUDIT
Drop public synonym delete any PUBLIC synonyms
Drop rollback segment Delete All ROLLBACK segments
------------------
Become user permission for switching USER status
CHANGE NOTIFICATION
Debug connect session debug connection SESSION
Force transaction manages the output permissions of uncommitted user transactions
Global query rewrite global data warehouse Index
On commit refresh: after the transaction commit of the base table, the materialized views will be refreshed immediately.
Query rewrite global data warehouse Index
Restricted session bound sessions
RESUMABLE recoverability
UNDER ANY TABLE
Under any type is of TYPE
Under any view under any table
ADVISOR

The red part is still difficult to explain, do not understand, do not know where to put

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.