Oracle Database SQL — Question 199

Which two are true about the WITH GRANT OPTION clause? (Choose two.)

Answer options

• A. It can be used for system and object privileges.
• B. The grantee can grant the object privilege to any user in the database, with or without including this option.
• C. The grantee must have the GRANT ANY OBJECT PRIVILEGE system privilege to use this option.
• D. It cannot be used to pass on privileges to PUBLIC by the grantee.
• E. It can be used when granting privileges to roles.
• F. It can be used to pass on privileges to other users by the grantee.

Correct answer: B, F

Explanation

Options B and F are correct because the grantee can indeed share the object privilege with any user and can also pass on privileges to other users. Options A, C, D, and E are incorrect as they do not accurately reflect the limitations or capabilities of the WITH GRANT OPTION clause.