Which three are true about privileges and roles? (Choose three.)

The correct answer is B. A role can contain a combination of several privileges and roles. D. A user has all object privileges for every object in their schema by default. G. PUBLIC acts as a default role granted to every user in a database. https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1010570

Controlling User Access

Question

Options

AA role is owned by the user who created it.
BA role can contain a combination of several privileges and roles.
CSystem privileges always set privileges for an entire database.
DA user has all object privileges for every object in their schema by default.
EAll roles are owned by the SYS schema.
FPUBLIC can be revoked from a user.
GPUBLIC acts as a default role granted to every user in a database.

How the community answered

(24 responses)

A
4% (1)
B
75% (18)
C
13% (3)
F
8% (2)

Explanation

https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1010570

Topics

#roles#system privileges#PUBLIC role#object privileges

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice