OCP-1Z0-052-V8 02-9题
发布时间：2020-12-14 04:27:21 所属栏目：大数据 来源：网络整理
导读：9. View the Exhibit and examine the privileges granted to the SL_REP user.? The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL GRANT SELECT ON scott.emp TO hr; Which statement describes the outcom
|
9. View the Exhibit and examine the privileges granted to the SL_REP user.?
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command? ? A.The command executes successfully. B.The command produces an error because the EMP table is owned by SCOTT. C.The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION. D.The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table. Answer: A??
答案解析：
环境测试一下：
1、创建一个用户，并解锁
[email?protected]> create user SL_REP identified by 123 account unlock;
?
User created.
2、将connect、resource角色赋予
[email?protected]> grant connect,resource to SL_REP;
?
Grant succeeded.
3、将grant any object privilege?赋予
?
[email?protected]> grant grant any object privilege to SL_REP;
?
Grant succeeded.
4、SL_REP连接数据库，开始授予hr访问scott的emp表，赋予成功。所以选择A。
[email?protected]> conn SL_REP/123
Connected.
?
[email?protected]> grant select on scott.emp to hr;
?
Grant succeeded.
再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！希望你也加入到我们人工智能的队伍中来！http://www.captainbed.net （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
