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

The correct answer is D. Object privileges granted on a table automatically apply to all synonyms for that table. E. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges F. Schema owners can grant any object privilege on any object in their schema to any other user or. Object privileges granted for a table, view, sequence, procedure, function, or package apply whether referencing the base object by name or by using a synonym. A user with the GRANT ANY OBJECT PRIVILEGE can grant or revoke any specified object privilege to another user A user…

Controlling User Access

Question

Options

AOnly users with the DBA role can create roles.
BA combination of object and system privileges can be granted to a role.
CAll schema objects have associated object privileges.
DObject privileges granted on a table automatically apply to all synonyms for that table.
EOnly users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges
FSchema owners can grant any object privilege on any object in their schema to any other user or

How the community answered

(26 responses)

A
4% (1)
B
4% (1)
C
15% (4)
D
77% (20)

Explanation

Object privileges granted for a table, view, sequence, procedure, function, or package apply whether referencing the base object by name or by using a synonym. A user with the GRANT ANY OBJECT PRIVILEGE can grant or revoke any specified object privilege to another user A user can grant any object privilege on any schema object he or she owns to any other user or https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#DBSEG5000 https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#DBSEG5000 https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#DBSEG5000

Topics

#object privileges#system privileges#GRANT ANY PRIVILEGE#schema owner grants

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice