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.