Shulou(Shulou.com)06/01 Report--

-| permission definition explanation-| level 1 permissions | Authorization level permissions for other users | level 2 permissions | oracle internal file management level permissions | level 3 permissions | session, role User-level permissions | level 4 permissions | tablespace level permissions | level 5 permissions | Database operation level permissions | level 6 permissions | arbitrary operation permissions on tables | level 7 permissions | only the permissions for operating tables in the current tablespace-| permission level permission description | level 1 permission granted by GRANT ANY OBJECT PRIVILEGE Arbitrary object permissions GRANT ANY PRIVILEGE Grant arbitrary system privilege permissions GRANT ANY ROLE authorizes roles | second-level permissions ADMINISTER ANY SQL TUNING SET manages any sql tuning set permissions for ADMINISTER DATABASE TRIGGER management database triggers ADMINISTER RESOURCE MANAGER resource management ADMINISTER SQL TUNING SET management sql adjustment sets MANAGE ANY FILE GROUP management any filegroup MANAGE ANY QUEUE management arbitrary queue MANAGE FILE GROUP management filegroup MANAGE SCHEDULER management scheme permissions MANAGE TABLESPACE management Manage the permissions of the tablespace | level 3 permissions CREATE SESSION create session permissions CREATE USER create user CREATE ROLE create roles ALTER SESSION modify session permissions ALTER SYSTEM modify database server settings permissions ALTER USER modify user ALTER ANY ROLE modify role permissions DROP USER delete user permissions DROP ANY ROLE delete any roles | level 4 permissions UNLIMITED TABLESPACE unlimited permissions on tablespace size (the default permissions after adding new users Even if the new user belongs to DBA, unless you specify other permissions Otherwise only have this default permission) CREATE TABLESPACE create tablespace permissions ALTER TABLESPACE modify tablespaces permissions DROP TABLESPACE delete any tablespaces permissions | level 5 permissions CREATE DATABASE LINK create database connections permissions ALTER DATABASE modify database permissions CREATE PUBLIC DATABASE LINK create public database links 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 submit any table permission DELETE ANY TABLE delete any table permission INSERT ANY TABLE insert records into any table permission BACKUP ANY TABLE backup table permission CREATE ANY CLUSTER create arbitrary cluster permission CREATE ANY CONTEXT create any context permission CREATE ANY DIMENSION modify any dimension permission CREATE ANY DIRECTORY create dictionary CREATE ANY EVALUATION CONTEXT create context CREATE ANY INDEX create index permission CREATE ANY INDEXTYPE create Permissions for any index type CREATE ANY JOB creation task CREATE ANY LIBRARY creation arbitrary library CREATE ANY MATERIALIZED VIEW creation any entity view CREATE ANY OPERATOR creation operator CREATE ANY OUTLINE create any execution plan CREATE ANY PROCEDURE creation stored procedure permission CREATE ANY RULE create any rule CREATE ANY RULE SET create any rule set CREATE ANY SEQUENCE create any sequence permission CREATE ANY SQL PROFILE create any sql profile CREATE ANY SYNONYM create Any synonym permission CREATE ANY TABLE create any table permission CREATE ANY TRIGGER create any trigger permission CREATE ANY TYPE create any type permission CREATE ANY VIEW create view permission ALTER ANY LIBRARY modify any library permission ALTER ANY CLUSTER modify any cluster permission ALTER ANY DIMENSION modify any dimension permission ALTER ANY EVALUATION CONTEXT modify any context ALTER ANY INDEX modify index permission ALTER ANY INDEXTYPE modify any index type Permissions ALTER ANY MATERIALIZED VIEW modify any entity view ALTER ANY OUTLINE modify any fixed execution plan ALTER ANY PROCEDURE modify any stored procedure permission ALTER ANY RULE modify any rule ALTER ANY RULE SET modify rule set ALTER ANY SEQUENCE modify any sequence permission ALTER ANY SQL PROFILE modify any sql configuration file ALTER ANY TABLE modify any table permission ALTER ANY TRIGGER modify any trigger permission ALTER ANY TYPE modify any type Permissions DROP ANY CLUSTER delete any cluster DROP ANY CONTEXT delete any DROP ANY DIMENSION delete any dimension permission DROP ANY DIRECTORY delete dictionary DROP ANY EVALUATION CONTEXT delete any context DROP ANY INDEX delete any index type DROP ANY LIBRARY delete library DROP ANY MATERIALIZED VIEW delete any entity view DROP ANY OPERATOR delete any operator DROP ANY OUTLINE delete any fixed execution plan DROP ANY PROCEDURE delete any What stored procedure permission DROP ANY RULE delete any rule permission DROP ANY RULE SET delete any rule set DROP ANY SEQUENCE delete any sequence permission DROP ANY SQL PROFILE delete any sql profile DROP ANY SYNONYM delete any synonym permission DROP ANY TABLE delete any table permission DROP ANY TRIGGER delete any trigger permission DROP ANY VIEW delete permission to delete view ENQUEUE ANY QUEUE to Permission to add messages to the queue EXECUTE ANY CLASS executes any class EXECUTE ANY EVALUATION CONTEXT executes any context EXECUTE ANY INDEXTYPE executes any index type EXECUTE ANY LIBRARY execution library EXECUTE ANY OPERATOR execution operator EXECUTE ANY PROCEDURE executes any stored procedure EXECUTE ANY PROGRAM executes any program EXECUTE ANY RULE executes any rule EXECUTE ANY RULE SET executes any rule set EXECUTE ANY TYPE executes any type of permission UPDATE ANY TABLE update any The permissions of the table DEQUEUE ANY QUEUE can query the permissions of all queues to make messages dequeue SELECT ANY SEQUENCE query the permissions of any sequence SELECT ANY TABLE query the permissions of any table SELECT ANY TRANSACTION query any transaction FLASHBACK ANY TABLE flashback any table FORCE ANY TRANSACTION manage the output permissions of any uncommitted transaction ANALYZE ANY use the analyze command to analyze any table in the database, Index and cluster AUDIT ANY set audit options for any database object READ ANY FILE GROUP read any filegroup LOCK ANY TABLE lock any table MERGE ANY VIEW merge view DEBUG ANY PROCEDURE debug any program | level 7 permission CREATE CLUSTER create cluster permission CREATE DIMENSION create dimension permission CREATE EVALUATION CONTEXT create context CREATE EXTERNAL JOB create any external task CREATE INDEXTYPE create index type CREATE JOB create task CREATE LIBRARY create library permission CREATE MATERIALIZED VIEW create entity view CREATE OPERATOR define a new operator CREATE PROCEDURE create stored procedure permissions CREATE PROFILE create resource restrictions profile permissions CREATE PUBLIC SYNONYM create public synonyms CREATE ROLLBACK SEGMENT create rollback segment CREATE RULE create rules permissions CREATE RULE SET create rule sets permissions CREATE SEQUENCE create sequence permissions CREATE SYNONYM create synonyms CREATE TABLE create table permissions CREATE TRIGGER create trigger permissions CREATE TYPE create classes Type CREATE VIEW permissions to create views ALTER PROFILE modify resource restrictions profile permissions ALTER RESOURCE COST set resource overhead permissions ALTER ROLLBACK SEGMENT modify rollback segment permissions DROP PROFILE delete resource limit profiles permissions AUDIT SYSTEM allows system operation audit DROP PUBLIC SYNONYM to delete any common synonyms DROP ROLLBACK SEGMENT delete all rollback segments 2. License GRANT CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW, CREATE ANY INDEX, CREATE ANY PROCEDURE, ALTER ANY TABLE, ALTER ANY PROCEDURE, DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE, SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO ogg; GRANT SELECT ANY TABLE, EXECUTE ANY PROCEDURE TO oa; grant EXECUTE ANY PROCEDURE to mes; 3. Query permissions-check the specific user permissions, sys administrator login: select * from dba_tab_privs where grantee=''select * FROM TABLE_PRIVILEGES where GRANTEE='';-view the permissions of the current user, and when the current user logs in: select * from user_sys_privs; SELECT * FROM dba_users WHERE account_status $apos;$OPEN' AND username LIKE'%'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.