Which three statements are true about roles?

The correct answer is B. Object privileges may not be granted to roles. C. The SET ROLE statement can disable one or more roles for a session. E. Roles may be granted to roles. See the full explanation below for the reasoning.

Administer User Security

Question

Options

AAll roles granted to a user are set on by default when the user logs in,
BObject privileges may not be granted to roles.
CThe SET ROLE statement can disable one or more roles for a session.
DRoles must be password protected.
ERoles may be granted to roles.
FThe SET ROLE statement can enable one or more roles for a session.

How the community answered

(33 responses)

A
6% (2)
B
82% (27)
D
3% (1)
F
9% (3)

Topics

#roles#SET ROLE#role privileges#role hierarchy

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice