What is true about the WITH GRANT OPTION clause?

What is true about the WITH GRANT OPTION clause?

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.



Leave a Reply 0

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