What is true about the WITH GRANT OPTION clause?

The correct answer is E. It allows the grantee to grant object privileges to other users and roles. 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…

Controlling User Access

Question

Options

AIt allows a grantee DBA privileges.
BIt is required syntax for object privileges.
CIt allows privileges on specified columns of tables.
DIt is used to grant an object privilege on a foreign key column.
EIt allows the grantee to grant object privileges to other users and roles.

How the community answered

(43 responses)

A
2% (1)
B
5% (2)
C
2% (1)
D
12% (5)
E
79% (34)

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.

Topics

#WITH GRANT OPTION#object privileges#privilege propagation#GRANT

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice