OCP-1Z0-052-V8 02-154题

喜欢ヅ旅行 2022-03-17 00:42 29阅读 0赞

154. View the Exhibit and examine the privileges granted to the MGR\_ROLE role.

![SouthEast][]

The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator

(DBA) grants MGR\_ROLE to the user SKD by executing the command:

SQL> GRANT MGR\_ROLE TO SKD WITH ADMIN OPTION;

Which statement is true about the user SKD after he/she is granted this role?

A.The user SKD can grant only the MGR\_ROLE role to other users, but not the privileges in it.

B.The user SKD can revoke the MGR\_ROLE only from the users for whom he/she is the grantor.

C.The user SKD can grant the privileges in the MGR\_ROLE role to other users, but not with ADMIN

OPTION.

D.The user SKD can grant the privileges in the MGR\_ROLE role to other users, but cannot revoke

privileges from them.

Answer: A

答案解析：

实验验证：

sys@TEST0924> create user SKD identified by SKD;

User created.

sys@TEST0924> grant connect,resource to SKD;

Grant succeeded.

sys@TEST0924> create role MGR\_ROLE;

Role created.

sys@TEST0924> grant create role to MGR\_ROLE;

Grant succeeded.

sys@TEST0924> grant create user to MGR\_ROLE;

Grant succeeded.

sys@TEST0924> grant select any table to MGR\_ROLE;

Grant succeeded.

查dba\_sys\_privs、dba\_role\_privs,dba\_tab\_privs三个视图看用户到底有哪些权限

sys@TEST0924>select \* from dba\_role\_privs where grantee='MGR\_ROLE';

no rows selected

sys@TEST0924> select \* from role\_sys\_privs where role='MGR\_ROLE';

ROLE PRIVILEGE ADM

\------------------------------ ---------------------------------------- ---

MGR\_ROLE SELECT ANY TABLE NO

MGR\_ROLE CREATE ROLE NO

MGR\_ROLE CREATE USER NO

sys@TEST0924> select \* from role\_tab\_privs where role='MGR\_ROLE';

no rows selected

WITH ADMIN OPTION的意思是被授予该权限的用户有权将某个权限(如MGR\_ROLE)授予其他用户或角色，取消是不级联的。

sys@TEST0924> GRANT MGR\_ROLE TO SKD WITH ADMIN OPTION;

Grant succeeded.

sys@TEST0924> create user user1 identified by test1;

User created.

sys@TEST0924> grant create session to user1;

Grant succeeded.

skd@TEST0924> grant MGR\_ROLE to user1;

Grant succeeded.

skd@TEST0924> grant create user to user1;

grant create user to user1

\*

ERROR at line 1:

ORA-01031: insufficient privileges

A正确，可以授权给MGR\_ROLE给别的用户，但不能把MGR\_ROLE里面的权限如create user授权给别的用户。

B错误，可以级联回收，可以回收不是SKD自己授予的。  
C错，错误。The user SKD can grant the privileges in the MGR\_ROLE role to other users。根据A答案，SKD不能将MGR\_ROLE角色里的权限给别的用户。

D,也可以回收权限。

skd@TEST0924> revoke MGR\_ROLE from user1;

Revoke succeeded.

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

[SouthEast]: /images/20220317/68dad9f23b5044bc98bfb87a99738a92.png
[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485

发表评论取消回复

表情：

评论列表（有 0 条评论，29人围观）

还没有评论，来说两句吧...

相关阅读

相关 OCP-1Z0-052-V8 02-10题

10. Examine the following statement that is used to modify the constraint on the SALES t

电玩女神/ 2022年04月23日 03:34/ 0 赞/ 138 阅读

相关 OCP-1Z0-052-V8 02-1题

1. View the Exhibit and examine the attributes of an undo tablespace. ![SouthEast][] I

女爷i/ 2022年03月27日 11:46/ 0 赞/ 151 阅读

相关 OCP-1Z0-052-V8 02-2题

2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose

我会带着你远行/ 2022年03月25日 10:46/ 0 赞/ 71 阅读

相关 OCP-1Z0-052-V8 02-9题

9. View the Exhibit and examine the privileges granted to the SL\_REP user. ![SouthEast

我不是女神ヾ/ 2022年03月22日 02:30/ 0 赞/ 150 阅读

相关 OCP-1Z0-052-V8 02-26题

26. Which two statements are true regarding undo tablespaces? (Choose two.) A.The datab

川长思鸟来/ 2022年03月21日 13:18/ 0 赞/ 48 阅读

相关 OCP-1Z0-052-V8 02-57题

57. Automatic Shared Memory Management is disabled for your database instance. You reali

水深无声/ 2022年03月20日 15:54/ 0 赞/ 55 阅读

相关 OCP-1Z0-052-V8 02-15题

15. Which two statements are true about Shared SQL Area and Private SQL Area? (Choose tw

àì夳堔傛蜴生んèń/ 2022年03月20日 10:30/ 0 赞/ 113 阅读

相关 OCP-1Z0-052-V8 02-145题

145. Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRK

港控/mmm°/ 2022年03月20日 06:13/ 0 赞/ 140 阅读

相关 OCP-1Z0-052-V8 02-97题

97. Which statement is true about loading data using the conventional path of SQL\Loader

小鱼儿/ 2022年03月18日 09:08/ 0 赞/ 145 阅读

相关 OCP-1Z0-052-V8 02-154题

154. View the Exhibit and examine the privileges granted to the MGR\_ROLE role. ![South

喜欢ヅ旅行/ 2022年03月17日 00:42/ 0 赞/ 30 阅读