问题:
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 withoutADMIN_OPTION.
D . The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table.
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()
● 参考解析
环境测试一下:
1、创建一个用户,并解锁
sys@TEST0924> create user SL_REP identified by 123 account unlock; User created.
2、将connect、resource角色赋予
sys@TEST0924> grant connect,resource to SL_REP; Grant succeeded.
3、将grant any object privilege 赋予
sys@TEST0924> grant grant any object privilege to SL_REP; Grant succeeded.
4、SL_REP连接数据库,开始授予hr访问scott的emp表,赋予成功。所以选择A。
sys@TEST0924> conn SL_REP/123 Connected.
sl_rep@TEST0924> grant select on scott.emp to hr; Grant succeeded.
相关内容
相关标签