没有合适的资源？快使用搜索试试~ 我知道了~

文库首页数据库OracleOracle系统权限和对象权限

Oracle系统权限和对象权限

oracle

需积分: 0 0 下载量 102 浏览量 2024-03-05 09:26:22 上传评论收藏 641KB PDF 举报

温馨提示

试读

28页

Oracle系统权限和对象权限

资源推荐

资源详情

资源评论

oracle数据库的权限系统分为系统权限与对象权限

oracle数据库的权限系统分为系统权限与对象权限

$message/rfc822\011$

Table 18-1 System Privileges (Organized by the Database Object Operated Upon)

System

Privilege Name

Operations Authorized

Advisor

Framework

Privileges: All of

the advisor

framework

privileges are part

of the DBA role.

—

ADVISOR

Access the advisor framework through PL/SQL packages such

as DBMS_ADVISOR and DBMS_SQLTUNE.

Refer to Oracle Database PL/SQL Packages and Types Referencefor

information on these packages.

ADMINISTER SQL

TUNING SET

Create, drop, select (read), load (write), and delete a SQL tuning set owned

by the grantee through the

DBMS_SQLTUNE

package.

ADMINISTER ANY

SQL TUNING SET

Create, drop, select (read), load (write), and delete a SQL tuning set owned

by any user through the

DBMS_SQLTUNE

package.

CREATE ANY SQL

PROFILE

Accept a SQL Profile recommended by the SQL Tuning Advisor, which is

accessed through Enterprise Manager or by the

DBMS_SQLTUNE

package.

Note: This privilege has been deprecated in favor

of ADMINISTERSQL MANAGEMENT OBJECT.

ALTER ANY SQL

PROFILE

Alter the attributes of an existing SQL Profile.

Note: This privilege has been deprecated in favor

of ADMINISTERSQL MANAGEMENT OBJECT.

DROP ANY SQL

PROFILE

Drop existing SQL Profiles.

Note: This privilege has been deprecated in favor

ADMINISTERSQL MANAGEMENT OBJECT

ADMINISTER SQL

MANAGEMENT

OBJECT

Create, alter, and drop SQL Profiles owned by any user through

the

DBMS_SQLTUNE

package.

CLUSTERS:

—

CREATE CLUSTER

Create clusters in the grantee's schema.

System

Privilege Name

Operations Authorized

CREATE ANY

CLUSTER

Create clusters in any schema except SYS. Behaves similarly

to CREATE ANY TABLE.

ALTER ANY

CLUSTER

Alter clusters in any schema except SYS.

DROP ANY

CLUSTER

Drop clusters in any schema except SYS.

CONTEXTS:

—

CREATE ANY

CONTEXT

Create any context namespace.

DROP ANY

CONTEXT

Drop any context namespace.

DATA

REDACTION:

—

EXEMPT REDACTI

ON POLICY

Bypass any existing Oracle Data Redaction policies and view actual data

from tables or views on which Data Redaction policies are defined.

DATABASE:

—

ALTER DATABASE

Alter the database.

ALTER SYSTEM

Issue ALTER SYSTEM statements.

AUDIT SYSTEM

Issue AUDIT statements.

DATABASE LINKS:

—

CREATE

DATABASE LINK

Create private database links in the grantee's schema.

CREATE PUBLIC

DATABASE LINK

Create public database links.

ALTER DATABASE

LINK

Modify a fixed-user database link when the password of the connection or

authentication user changes.

ALTER PUBLIC D

ATABASE LINK

Modify a public fixed-user database link when the password of the

connection or authentication user changes.

System

Privilege Name

Operations Authorized

DROP PUBLIC

DATABASE LINK

Drop public database links.

DEBUGGING:

—

DEBUG CONNECT

SESSION

Connect the current session to a debugger.

DEBUG ANY PROC

EDURE

Debug all PL/SQL and Java code in any database object. Display information

on all SQL statements executed by the application.

Note: Granting this privilege is equivalent to granting the

DEBUG

object

privilege on all applicable objects in the database.

DICTIONARIES:

—

ANALYZE ANY DI

CTIONARY

Analyze any data dictionary object.

DIMENSIONS:

—

CREATE

DIMENSION

Create dimensions in the grantee's schema.

CREATE ANY

DIMENSION

Create dimensions in any schema except

SYS

ALTER ANY

DIMENSION

Alter dimensions in any schema except

SYS

DROP ANY

DIMENSION

Drop dimensions in any schema except

SYS

DIRECTORIES:

—

CREATE ANY

DIRECTORY

Drop directory database objects.

EDITIONS:

—

CREATE ANY

EDITION

Create editions.

System

Privilege Name

Operations Authorized

DROP ANY

EDITION

Drop editions.

FLASHBACK

DATA ARCHIVES:

—

FLASHBACK ARCH

IVE ADMINISTER

Create, alter, or drop any flashback data archive.

INDEXES:

—

CREATE ANY

INDEX

Create in any schema, except SYS, a domain index or an index on any table

in any schema except SYS.

ALTER ANY

INDEX

Alter indexes in any schema except SYS.

DROP ANY INDEX

Drop indexes in any schema except SYS.

INDEXTYPES:

—

CREATE

INDEXTYPE

Create indextypes in the grantee's schema.

CREATE ANY

INDEXTYPE

Create indextypes in any schema except SYS and create comments on an

indextype in any schema except SYS.

ALTER ANY

INDEXTYPE

Modify indextypes in any schema except SYS.

DROP ANY

INDEXTYPE

Drop indextypes in any schema except SYS.

EXECUTE ANY

INDEXTYPE

Reference indextypes in any schema except SYS.

JOB SCHEDULER

OBJECTS:

The following privileges are needed to execute procedures in

the DBMS_SCHEDULER package. This privileges do not apply to lightweight

jobs, which are not database objects. Refer to Oracle Database

Administrator's Guide for more information about lightweight jobs.

CREATE JOB

Create, alter, or drop jobs, chains, schedules, programs, or credentials in

the grantee's schema.

CREATE ANY JOB

Create, alter, or drop jobs, chains, schedules, programs, or credentials in

System

Privilege Name

Operations Authorized

any schema except SYS.

Note: This extremely powerful privilege allows the grantee to execute code

as any other user. It should be granted with caution.

CREATE

EXTERNAL JOB

Create in the grantee's schema an executable scheduler job that runs on

the operating system.

EXECUTE ANY

CLASS

Specify any job class in a job in the grantee's schema.

EXECUTE ANY

PROGRAM

Use any program in a job in the grantee's schema.

MANAGE

SCHEDULER

Create, alter, or drop any job class, window, or window group.

KEY

MANAGEMENT

FRAMEWORK:

—

ADMINISTER KEY

MANAGEMENT

Manage keys and keystores.

LIBRARIES:

Caution:

CREATE LIBARARY

CREATE ANY LIBRARY

ALTER ANYLIBRARY

and

EXECUTE ANY LIBRARY

are extremely powerful privileges that should

be granted only to trusted users. Refer to Oracle Database Security

Guide before granting these privileges.

CREATE LIBRARY

Create external procedure or function libraries in the grantee's schema.

CREATE ANY

LIBRARY

Create external procedure or function libraries in any schema except

SYS

ALTER ANY

LIBRARY

Alter external procedure or function libraries in any schema except

SYS

DROP ANY

LIBRARY

Drop external procedure or function libraries in any schema except

SYS

EXECUTE ANY

LIBRARY

Use external procedure or function libraries in any schema except

SYS

LOGMINER:

—

剩余27页未读，继续阅读

评论收藏

内容反馈

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

CodeGolang

粉丝: 55
资源: 1088

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

Oracle系统权限和对象权限

oracle数据库的权限系统分为系统权限与对象权限

oracle的系统和对象权限

Oracle用户与对象权限与系统权限

全面解析Oracle数据库的系统和对象权限

Oracle系统权限说明

oracle数据库权限管理

oracle查看用户权限

oracle 实验六 模式对象管理与安全管理

oracle权限角色

根据用户批量授权对象权限脚本.txt

ora_oracle权限

Oracle权限管理

oracle查询用户信息

DEV基本权限管理项目代码整套

Oracle创建表空间、创建用户、授权、授权对象的访问以及查看权限

Oracle 教程 Oracle Server

查看oracle数据库的连接数以及用户、数据库锁定进程

Oracle数据操作和控制语言详解.pdf

学生成绩管理系统Oracle全部SQL语句.txt

oci.dll 12版本全部

数据库系统概念（原书第七版）课后作业题

fineReport课后10题答案.zip

win64-11gR2-client.zip

Oracle19c-Windows客户端

oracle 12c windows 安装包下载

Kingbase KCA题库

Oracle11安装依赖包，11.2.0.4.0版本

Oracle19c(19.3)数据库驱动ojdbc.jar

最新资源

oracle 实验六模式对象管理与安全管理