单选题
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（） AThe command executes successfully.
BThe command produces an error because the EMP table is owned by SCOTT.
CThe command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
DThe command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table.
正确答案
答案解析
环境测试一下：
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.
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.
相似试题
View the Exhibit. Which statements are true regarding the USERS tablespace（）
多选题查看答案
View the Exhibit and identify the component marked with a question mark. （）
单选题查看答案
View the Exhibit and identify the component marked with a question mark.（）
单选题查看答案
View the Exhibit and examine the output of the query. What do you infer from this（）
单选题查看答案
View the Exhibit and examine the output of the query. What do you infer from this（）
单选题查看答案
View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries？ （）
单选题查看答案
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（）
多选题查看答案
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command（）
单选题查看答案
View the Exhibit and examine the output. Which two statements are true regarding the LISTENER2 listener（）
多选题查看答案
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident（）
单选题查看答案