首页

oracle系统权限大全chm版本电子手册下载

标签:System Privileges,oracle权限大全     发布时间:2021-12-24   
  • 云盘下载:
  • [提取码:87ab]
  • 本地下载:
       ( 需积分:2  )

System Privileges

System Privilege Operations Authorized
ALTER ANY CLUSTER Allows grantee to alter any cluster in any schema.
ALTER ANY INDEX Allows grantee to alter any index in any schema
ALTER ANY PROCEDURE Allows grantee to alter any stored procedure,
function, or package in any schema.
ALTER ANY ROLE Allows grantee to alter any role in the database.
ALTER ANY SEQUENCE Allows grantee to alter any sequence in the database.
ALTER ANY SNAPSHOT Allows grantee to alter any snapshot in the database.
ALTER ANY TABLE Allows grantee to alter any table or view in the
schema.
ALTER ANY TRIGGER Allows grantee to enable, disable, or compile any
database trigger in any schema.
ALTER DATABASE Allows grantee to alter the database.
ALTER PROFILE Allows grantee to alter profiles.
ALTER RESOURCE COST Allows grantee to set costs for session resources.
ALTER ROLLBACK SEGMENT Allows grantee to alter rollback segments.
ALTER SESSION Allows grantee to issue ALTER SESSION statements.
ALTER SYSTEM Allows grantee to issue ALTER SYSTEM statements.
ALTER TABLESPACE Allows grantee to alter tablespaces.
ALTER USER Allows grantee to alter any user. This privilege
authorizes the grantee to change another user's password or authentication
method, assign quotas on any tablespace, set default and temporary
tablespaces, and assign a profile and default roles.
ANALYZE ANY Allows grantee to analyze any table, cluster, or index
in any schema.
AUDIT ANY Allows grantee to audit any object in any schema using
AUDIT (Schema Objects) statements.
AUDIT SYSTEM Allows grantee to issue AUDIT (SQL Statements)
statements.
BACKUP ANY TABLE Allows grantee to use the Export utility to
incrementally export objects from the schema of other users.
BECOME USER Allows grantee to become another user. (Required by
any user performing a full database import.)
COMMENT ANY TABLE Allows grantee to comment on any table, view, or
column in any schema.
CREATE ANY CLUSTER Allows grantee to create a cluster in any schema.
Behaves similarly to CREATE ANY TABLE.
CREATE ANY INDEX Allows grantee to create an index in any schema on any
table in any schema.
CREATE ANY PROCEDURE Allows grantee to create stored procedures, functions,
and packages in any schema.
CREATE ANY SEQUENCE Allows grantee to create a sequence in any schema.
CREATE ANY SNAPSHOT Allows grantee to create snapshots in any schema.
CREATE ANY SYNONYM Allows grantee to create private synonyms in any
schema.
CREATE ANY TABLE Allows grantee to create tables in any schema. The
owner of the schema containing the table must have space quota on the tablespace
to contain the table.
CREATE ANY TRIGGER Allows grantee to create a database trigger in any
schema associated with a table in any schema.
CREATE ANY VIEW Allows grantee to create views in any schema.
CREATE CLUSTER Allows grantee to create clusters in own schema.
CREATE DATABASE LINK Allows grantee to create private database links in own
schema.
CREATE PROCEDURE Allows grantee to create stored procedures, functions,
and packages in own schema.
CREATE PROFILE Allows grantee to create profiles.
CREATE PUBLIC DATABASE LINK Allows grantee to create public database links.
CREATE PUBLIC SYNONYM Allows grantee to create public synonyms.
CREATE ROLE Allows grantee to create roles.
CREATE ROLLBACK SEGMENT Allows grantee to create rollback segments.
CREATE SEQUENCE Allows grantee to create sequences in own schema.
CREATE SESSION Allows grantee to connect to the database.
CREATE SNAPSHOT Allows grantee to create snapshots in own schema.
CREATE SYNONYM Allows grantee to create synonyms in own schema.
CREATE TABLE Allows grantee to create tables in own schema. To
create a table, the grantee must also have space quota on the tablespace to
contain the table.
CREATE TABLESPACE Allows grantee to create tablespaces.
CREATE TRIGGER Allows grantee to create a database trigger in own
schema.
CREATE USER Allows grantee to create users. This privilege also
allows the creator to assign quotas on any tablespace, set default and
temporary tablespaces, and assign a profile as part of a CREATE USER statement.
CREATE VIEW Allows grantee to create views in own schema.
DELETE ANY TABLE Allows grantee to delete rows from tables or views in
any schema or truncate tables in any schema.
DROP ANY CLUSTER Allows grantee to drop clusters in any schema.
DROP ANY INDEX Allows grantee to drop indexes in any schema.
DROP ANY PROCEDURE Allows grantee to drop stored procedures, functions,
or packages in any schema.
DROP ANY ROLE Allows grantee to drop roles.
DROP ANY SEQUENCE Allows grantee to drop sequences in any schema.
DROP ANY SNAPSHOT Allows grantee to drop snapshots in any schema.
DROP ANY SYNONYM Allows grantee to drop private synonyms in any schema.
DROP ANY TABLE Allows grantee to drop tables in any schema.
DROP ANY TRIGGER Allows grantee to drop database triggers in any
schema.
DROP ANY VIEW Allows grantee to drop views in any schema
DROP PROFILE Allows grantee to drop profiles.
DROP PUBLIC DATABASE LINK Allows grantee to drop public database links.
DROP PUBLIC SYNONYM Allows grantee to drop public synonyms.
DROP ROLLBACK SEGMENT Allows grantee to drop rollback segments.
DROP TABLESPACE Allows grantee to drop tablespaces.
DROP USER Allows grantee to drop users.
EXECUTE ANY PROCEDURE Allows grantee to execute procedures or functions
(stand-alone or packaged) or reference public package variables in any schema.
FORCE ANY TRANSACTION Allows grantee to for the commit or rollback of any
in-doubt distributed transaction in the local database. Also allows the grantee
to induce the failure of a distributed transaction.
FORCE TRANSACTION Allows grantee to force the commit or rollback of own
in-doubt distributed transactions in the local database.
GRANT ANY PRIVILEGE Allows grantee to grant any system privilege.
GRANT ANY ROLE Allows grantee to grant any role in the database.
INSERT ANY TABLE Allows grantee to insert rows into tables and views in
any schema.
LOCK ANY TABLE Allows grantee to lock tables and views in any schema.
MANAGE TABLESPACE Allows grantee to take tablespaces offline and online
and begin and end tablespace backups.
READUP Allows grantee to query data having an access class
higher than the grantee's session label. This privilege is only available in
Trusted Oracle7.
RESTRICTED SESSION Allows grantee to logon after the instance is started
using the Server Manager STARTUP RESTRICT command.
SELECT ANY SEQUENCE Allows grantee to reference sequences in any schema.
SELECT ANY TABLE Allows grantee to query tables, views, or snapshots in
any schema.
UNLIMITED TABLESPACE Allows grantee to use an unlimited amount of any
tablespace. This privilege overrides any specific quotas assigned. If you revoke
this privilege from a user, the grantee's schema objects remain but further
tablespace allocation is denied unless authorized by specific tablespace quotas.
You cannot grant this system privilege to roles.
UPDATE ANY TABLE Allows grantee to update rows in tables and views in
any schema.
WRITEDOWN Allows grantee to create, alter, and drop schema
objects and to insert, update, and delete rows having access classes lower than
the grantee's session label. This privilege is only available in Trusted
Oracle7.
WRITEUP Allows grantee to create, alter, and drop schema
objects and to insert, update, and delete rows having access classes higher than
the grantee's session label. This privilege is only available in Trusted
Oracle7.


  • ◆ 相关内容