DBMS_RULE_ADM和DBMS_AQADM包权限管理说明
来源:互联网 发布:windows fifo 读写文件 编辑:程序博客网 时间:2024/06/07 22:15
GRANT_SYSTEM_PRIVILEGE Procedure
privilege IN BINARY_INTEGER,
grantee IN VARCHAR2,
privilege
The name of the system privilege to grant to the grantee.
grantee
The name of the user or role for which the privilege is granted
grant_option
If true, then the specified user or users granted the specified privilege can grant the system privilege to others.
If false, then the specified user or users granted the specified privilege cannot grant the system privilege to others.
REVOKE_SYSTEM_PRIVILEGE Procedure
DBMS_RULE_ADM.REVOKE_SYSTEM_PRIVILEGE(
privilege IN BINARY_INTEGER,
revokee IN VARCHAR2);
Parameter Description
privilege
The name of the system privilege to revoke from the revokee. See "GRANT_SYSTEM_PRIVILEGE Procedure" for a list of the system privileges.
revokee
The name of the user or role from which the privilege is revoked
DBMS_RULE_ADM过程的两个例子
例子:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.DROP_ANY_RULE_SET,
GRANTEE => 'SCOTT',
GRANT_OPTION => FALSE);
END;
/
BEGIN
SYS.DBMS_RULE_ADM.REVOKE_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.DROP_ANY_RULE,
REVOKEE => 'SCOTT');
END;
/
DBMS_AQADM过程的两个例子
例子:
BEGIN
SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE (
PRIVILEGE => 'MANAGE_ANY',
GRANTEE => 'SCOTT',
ADMIN_OPTION => FALSE);
END;
/
BEGIN
SYS.DBMS_AQADM.REVOKE_SYSTEM_PRIVILEGE (
PRIVILEGE => 'MANAGE_ANY',
GRANTEE => 'SCOTT');
END;
/
Syntax
privilege IN BINARY_INTEGER,
grantee IN VARCHAR2,
grant_option IN BOOLEAN DEFAULT false);
privilege
The name of the system privilege to grant to the grantee.
grantee
The name of the user or role for which the privilege is granted
grant_option
If true, then the specified user or users granted the specified privilege can grant the system privilege to others.
If false, then the specified user or users granted the specified privilege cannot grant the system privilege to others.
REVOKE_SYSTEM_PRIVILEGE Procedure
DBMS_RULE_ADM.REVOKE_SYSTEM_PRIVILEGE(
privilege IN BINARY_INTEGER,
revokee IN VARCHAR2);
Parameter Description
privilege
The name of the system privilege to revoke from the revokee. See "GRANT_SYSTEM_PRIVILEGE Procedure" for a list of the system privileges.
revokee
The name of the user or role from which the privilege is revoked
DBMS_RULE_ADM过程的两个例子
例子:
BEGIN
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.DROP_ANY_RULE_SET,
GRANTEE => 'SCOTT',
GRANT_OPTION => FALSE);
END;
/
BEGIN
SYS.DBMS_RULE_ADM.REVOKE_SYSTEM_PRIVILEGE(
PRIVILEGE => SYS.DBMS_RULE_ADM.DROP_ANY_RULE,
REVOKEE => 'SCOTT');
END;
/
DBMS_AQADM过程的两个例子
例子:
BEGIN
SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE (
PRIVILEGE => 'MANAGE_ANY',
GRANTEE => 'SCOTT',
ADMIN_OPTION => FALSE);
END;
/
BEGIN
SYS.DBMS_AQADM.REVOKE_SYSTEM_PRIVILEGE (
PRIVILEGE => 'MANAGE_ANY',
GRANTEE => 'SCOTT');
END;
/
- DBMS_RULE_ADM和DBMS_AQADM包权限管理说明
- 文档管理-权限说明
- linux权限管理命令的一些细节和说明
- 【TFS权限管理】TFS用户组说明和用户权限配置过程
- android权限和说明
- 包和权限
- 包和访问权限
- 11.权限和权限管理
- pms包管理服务分析-权限管理和鉴权过程
- 用户和权限管理
- 账号和权限管理
- 用户和权限管理
- 用户组和权限管理
- 【系统设计】权限管理数据表设计说明
- 权限管理数据表设计说明(五张表)
- 权限管理说明-以Linux为例
- 07包和访问权限
- UAC权限和安装包
- MySQL字符集:保证不发生乱码的方法
- 黑马程序员_构造函数与构造代码块
- Java获取客户端代码大全
- 什么是QName
- java获取计算机cpu利用率和内存使用信息
- DBMS_RULE_ADM和DBMS_AQADM包权限管理说明
- 黑马程序员_静态的介绍
- GDB调试多线程
- Boost::lexical_cast
- 北京的十大尾货批发市场【接近生活】
- ubuntu/centos环境下玩android系统(三): windows下的android模拟器运行!
- 系统的学习
- listView动态加载数据分页
- 黑马程序员_单例设计模式