Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 89

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

    Correct Answer: A, C, E

    A combination of object and system privileges can indeed be granted to a role, which allows for greater flexibility in managing permissions. Schema owners have the ability to grant object privileges on objects within their schema to other users or roles. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users, emphasizing their unique authority in managing system-level permissions. Not all types of schema objects have associated object privileges, which excludes option B. The creation of roles is not exclusive to users with the DBA role, making option D incorrect. Additionally, object privileges granted on a table do not automatically apply to its synonyms, thus option F is also not correct.

Discussion
lucemqyOptions: ACF

ACF correct

TheOracleWasTaken

why not B?

lucemqy

https://docs.oracle.com/cd/A58617_01/server.804/a58227/ch18.htm Some schema objects do not have associated object privileges; their use is controlled with system privileges

Sbablo

why is E wrong ?

zouve

i think the "only" is killing it

astride

Why C is not correct?

kaplanek

A C F are correct