OCP-DBMS_RESOURCE_MANAGER_PRIVS
来源:互联网 发布:网络文明礼仪图片 编辑:程序博客网 时间:2024/06/06 07:25
93. You want to create a consumer group, GROUP1, and you execute the following command in the
commandline
interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP =>'group1', COMMENT => 'New Group');
This command errors out displaying the following message:
ERROR at line 1:
ORA01031:
insufficient privileges
ORA06512:
at "SYS.DBMS_RMIN", line 115
ORA06512:
at SYS.DBMS_RESOURCE_MANAGER", line 108
ORA06512:
at line 1
What action would you take to overcome this error?
A.grant SYSDBA to the user
B.grant SYSOPER to the user
C.grant the RESOURCE role to the user
D.use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the user
E.grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the
DBMS_RESOURCE_MANAGER_PRIVS package
Answer: E
DBMS_RESOURCE_MANAGER_PRIVS
The DBMS_RESOURCE_MANAGER_PRIVS
package maintains privileges associated with the Resource Manager.
See Also:
For more information on using the Database Resource Manager, see Oracle Database Administrator's Guide.This chapter contains the following topics:
Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
Summary of DBMS_RESOURCE_MANAGER_PRIVS Subprograms
Table 86-1 DBMS_RESOURCE_MANAGER_PRIVS Package Subprograms
GRANT_SWITCH_CONSUMER_GROUP Procedure
Grants the privilege to switch to resource consumer groups
GRANT_SYSTEM_PRIVILEGE Procedure
Performs a grant of a system privilege
REVOKE_SWITCH_CONSUMER_GROUP Procedure
Revokes the privilege to switch to resource consumer groups.
REVOKE_SYSTEM_PRIVILEGE Procedure
Performs a revoke of a system privilege
GRANT_SWITCH_CONSUMER_GROUP Procedure
This procedure grants the privilege to switch to a resource consumer group.
Syntax
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP ( grantee_name IN VARCHAR2, consumer_group IN VARCHAR2, grant_option IN BOOLEAN);
Parameters
Table 86-2 GRANT_SWITCH_CONSUMER_GROUP Procedure Parameters
grantee_name
Name of the user or role to whom privilege is to be granted.
consumer_group
Name of consumer group.
grant_option
TRUE
if grantee should be allowed to grant access, FALSE
otherwise.
Usage Notes
If you grant permission to switch to a particular consumer group to a user, then that user can immediately switch their current consumer group to the new consumer group.
If you grant permission to switch to a particular consumer group to a role, then any users who have been granted that role and have enabled that role can immediately switch their current consumer group to the new consumer group.
If you grant permission to switch to a particular consumer group to PUBLIC
, then any user can switch to that consumer group.
If the grant_option
parameter is TRUE
, then users granted switch privilege for the consumer group may also grant switch privileges for that consumer group to others.
In order to set the initial consumer group of a user, you must grant the switch privilege for that group to the user.
See Also:
Chapter 85, "DBMS_RESOURCE_MANAGER"Examples
BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP ( 'scott', 'mail_maintenance_group', true); DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA(); DBMS_RESOURCE_MANAGER.set_consumer_group_mapping( dbms_resource_manager.oracle_user, 'scott','mail_maintenance_group'); DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA(); END; /
GRANT_SYSTEM_PRIVILEGE Procedure
This procedure performs a grant of a system privilege to a user or role.
Syntax
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE ( grantee_name IN VARCHAR2, privilege_name IN VARCHAR2 DEFAULT 'ADMINISTER_RESOURCE_MANAGER', admin_option IN BOOLEAN);
Parameters
Table 86-3 GRANT_SYSTEM_PRIVILEGE Procedure Parameters
grantee_name
Name of the user or role to whom privilege is to be granted.
privilege_name
Name of the privilege to be granted.
admin_option
TRUE
if the grant is with admin_option
, FALSE
otherwise.
Usage Notes
Currently, Oracle provides only one system privilege for the Resource Manager: ADMINISTER_RESOURCE_MANAGER
. Database administrators have this system privilege with the ADMIN
option. The grantee and the revokee can either be a user or a role. Users that have been granted the system privilege with the ADMIN
option can also grant this privilege to others.
Examples
The following call grants this privilege to a user called scott
without the ADMIN
option:
BEGINDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE ( grantee_name => 'scott', privilege_name => 'ADMINISTER_RESOURCE_MANAGER', admin_option => FALSE);END;/
REVOKE_SWITCH_CONSUMER_GROUP Procedure
This procedure revokes the privilege to switch to a resource consumer group.
Syntax
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SWITCH_CONSUMER_GROUP ( revokee_name IN VARCHAR2, consumer_group IN VARCHAR2);
Parameters
Table 86-4 REVOKE_SWITCH_CONSUMER_GROUP Procedure Parameter
revokee_name
Name of user/role from which to revoke access.
consumer_group
Name of consumer group.
Usage Notes
If you revoke a user's switch privilege for a particular consumer group, then any subsequent attempts by that user to switch to that consumer group will fail.
If you revoke the initial consumer group from a user, then that user will automatically be part of the DEFAULT_CONSUMER_GROUP
consumer group when logging in.
If you revoke the switch privilege for a consumer group from a role, then any users who only had switch privilege for the consumer group through that role will not be able to switch to that consumer group.
If you revoke the switch privilege for a consumer group from PUBLIC
, then any users who could previously only use the consumer group through PUBLIC
will not be able to switch to that consumer group.
Examples
The following example revokes the privileges to switch to mail_maintenance_group
from Scott:
BEGINDBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SWITCH_CONSUMER_GROUP ( 'scott', 'mail_maintenance_group');END;/
REVOKE_SYSTEM_PRIVILEGE Procedure
This procedure performs a revoke of a system privilege from a user or role.
Syntax
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVILEGE ( revokee_name IN VARCHAR2, privilege_name IN VARCHAR2 DEFAULT 'ADMINISTER_RESOURCE_MANAGER');
Parameters
Table 86-5 REVOKE_SYSTEM_PRIVILEGE Procedure Parameters
revokee_name
Name of the user or role from whom privilege is to be revoked.
privilege_name
Name of the privilege to be revoked.
Examples
The following call revokes the ADMINISTER_RESOURCE_MANAGER
from user scott:
BEGINDBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVILEGE ('scott');END;/
- OCP-DBMS_RESOURCE_MANAGER_PRIVS
- dbms_resource_manager和dbms_resource_manager_privs
- ocp
- ocp
- OCP
- Ocp
- OCP
- ocp
- OCP
- ocp
- OCP考试
- OCP原则
- OCP题
- OCP构想
- OCP考试
- OCP原则
- oracle ocp
- 转载OCP
- 简单工厂模式
- android多媒体本地播放流程video playback--base on jellybean (五)
- 严重: Exception starting filter struts2
- SVN服务器搭建和使用(一,二)
- 菜鸟笔记-9月10日(关于jquery的一些应用)
- OCP-DBMS_RESOURCE_MANAGER_PRIVS
- android 实现下拉菜单
- Win8快速开关机的奥妙:假关机还是真休眠?
- 有关REST的一点学习笔记
- 项目第二阶段小结
- 分享35个讨人喜欢的漂亮进度条UI设计
- Java基本数据类型
- Dr.Sum EA是简单、高速、自助式的、易于推广的BI工具
- 扪心第五想 Accept the act 面带微笑,昂首前行