Which two are true about the WITH GRANT OPTION clause? (Choose two.)

The correct answer is D. It can be used for system and object privileges. E. It can be used to pass on privileges to other users by the grantee. https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm

Controlling User Access

Question

Options

AThe grantee must have the GRANT ANY OBJECT PRIVILEGE system privilege to use this
BIt can be used when granting privileges to roles.
CIt cannot be used to pass on privileges to PUBLIC by the grantee.
DIt can be used for system and object privileges.
EIt can be used to pass on privileges to other users by the grantee.
FThe grantee can grant the object privilege to any user in the database, with or without including

How the community answered

(46 responses)

A
13% (6)
B
7% (3)
C
2% (1)
D
76% (35)
F
2% (1)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm

Topics

#WITH GRANT OPTION#object privileges#system privileges#roles

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice