Exam 1z0-071 topic 1 question 257 discussion

WHAT ABOUT D , THAT ALSO CORRECT SEEMS,

B is the right answer as per this website https://docs.oracle.com/cd/B10500_01/server.920/a96521/privs.htm#21327 this website has same wording Specifying the GRANT OPTION Specify WITH GRANT OPTION to enable the grantee to grant the object privileges to other users and roles. The user whose schema contains an object is automatically granted all associated object privileges with the GRANT OPTION. This special privilege allows the grantee several expanded privileges: The grantee can grant the object privilege to any users in the database, with or without the GRANT OPTION, or to any role in the database. If both of the following are true, the grantee can create views on the table and grant the corresponding privileges on the views to any user or role in the database. The grantee receives object privileges for the table with the GRANT OPTION. The grantee has the CREATE VIEW or CREATE ANY VIEW system privilege.

Specify WITH GRANT OPTION to enable the grantee to grant the object privileges to other users and roles. The user whose schema contains an object is automatically granted all associated object privileges with the GRANT OPTION. This special privilege allows the grantee several expanded privileges: The grantee can grant the object privilege to any users in the database, with or without the GRANT OPTION, or to any role in the database. If both of the following are true, the grantee can create views on the table and grant the corresponding privileges on the views to any user or role in the database. The grantee receives object privileges for the table with the GRANT OPTION. The grantee has the CREATE VIEW or CREATE ANY VIEW system privilege. The GRANT OPTION is not valid when granting an object privilege to a role. Oracle prevents the propagation of object privileges through roles so that grantees of a role cannot propagate object privileges received by means of roles.

A is wrong - only object privileges https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/GRANT.html

A. It can be used for system and object privileges. This option allows the grantee to further grant the privilege or role to another user or role, unless the role is a GLOBAL role, which includes both system and object privileges . F. It can be used to pass on privileges to other users by the grantee. When a user is granted privileges or a role with the WITH GRANT OPTION, they can then grant those same privileges or roles to other users or roles. This does not apply to roles, as roles cannot be granted WITH GRANT OPTION .