Which two are true about the roles? (Choose two.)

The correct answer is A. All privileges and roles granted to a user are enabled by default when the user logs in. C. The SET ROLE statement enables as well as disables roles in a session. See the full explanation below for the reasoning.

Administer User Security

Question

Options

AAll privileges and roles granted to a user are enabled by default when the user logs in.
BThe SET ROLE statement can be used once per session.
CThe SET ROLE statement enables as well as disables roles in a session.
DA role must be disabled before it can be revoked from a user.
EThe ALTER USER statement must be used to set specific default roles for a user.

How the community answered

(51 responses)

A
75% (38)
B
16% (8)
D
4% (2)
E
6% (3)

Topics

#roles#SET ROLE#default roles#privilege management

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice