What is true about the WITH GRANT OPTION clause?
A.
It allows a grantee DBA privileges.
B.
It is required syntax for object privileges.
C.
It allows privileges on specified columns of tables.
D.
It is used to grant an object privilege on a foreign key column.
E.
It allows the grantee to grant object privileges to other users and roles.
Explanation:
The GRANT command with the WITH GRANT OPTION clause allows the grantee to grant object privileges to
other users and roles.
Incorrect Answers
A:. The WITH GRANT OPTION does not allow a grantee DBA privileges.
B:. It is not required syntax for object privileges. It is optional clause of GRANT command.
C:. GRANT command does not allows privileges on columns of tables.
D:. It is not used to grant an object privilege on a foreign key column.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-365
Chapter 8: User Access in Oracle
The WITH GRANT OPTION keywords convey the privilege or role to a user with the right to grant the same privileges or role to other users.
You create a chain of privileges that begins with you and extends to user as well as to whomever user subsequently conveys the right to grant privileges. If you include WITH GRANT OPTION, you can no longer control the dissemination of privileges.
The following example grants the Alter and Select privileges to user mark on the cust_seq sequence object, with the ability to grant those privileges to others:
GRANT ALL ON cust_seq TO mark WITH GRANT OPTION;copy to clipboard
If you revoke from user the privilege that you granted using the WITH GRANT OPTION keyword, you sever the chain of privileges. That is, when you revoke privileges from user, you automatically revoke the privileges of all users who received privileges from user or from the chain that user created (unless user, or the users who received privileges from user, were granted the same set of privileges by someone else).
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0125.htm