Which statement describes the outcome of the command?

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?

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 SL_REP does not have the SELECT privilege

with GRANT_OPTION on the EMP table

C.
The command produces an error because the EMP table is owned by SCOTT

D.
The command produces an error because SL_REP has the GRANT ANY OBJECT
PRIVILEGE without ADMIN_OPTION



Leave a Reply 1

Your email address will not be published. Required fields are marked *


MJ

MJ

The key here is the GRANT ANY OBJECT PRIVILEGE.