160.View the Exhibit to observe the roles assigned to the SLP_REP user.
Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REP
user?
A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes.
答案:A
解析:
A:正确,从图中可以看到角色SELECT_CATALOG_ROLE 的default为N,因此不是默认的,如果想要使用那么需要启用该角色
alter user slp_rep default role none; --将用户的默认角色设置为none
alter user slp_rep default role resource,connect; --设置三个都为默认角色
alter user slp_rep default role all;--设置所有的默认角色
alter user slp_rep default role all except SELECT_CATALOG_ROLE;--设置除了SELECT_CATALOG_ROLE其他都为默认的角色
select * from user_role_privs;--从字段DEF查看启用状态
set role overall_manage identified by password;--启用角色,如果有密码的话增加identified by password语句
set role none; --恢复默认
B:错误,首先它不是默认的,并且admin为N因此不可以授予其他用户
C:错误,前半句诗对的,他不能使用这个角色,需要启用一下,但是并不是dba来启用,而是它自己
D:错误,需要启用