SANA, RYAN and MARY are junior DBA’S of RUBY pluggable database. They are asked to provide multiple system and object level privileges to 10 newly joined database users. The dba’s make a discussion among themselves and put forward their statements as below.
MARY: System and object level privileges can be provided to the database users only through roles
SANA: Both system and object level privileges can be provided to the database users through role or as individual privileges
RYAN: Since there are 10 users to be provided with same privileges it is optimal to provide the system and object privileges to the users, by assigning role granted with required privileges.
Which of the above statements are TRUE with respect to the scenario?

Question

SANA, RYAN and MARY are junior DBA’S of RUBY pluggable database. They are asked to provide multiple system and object level privileges to 10 newly joined database users. The dba’s make a discussion among themselves and put forward their statements as below.

MARY: System and object level privileges can be provided to the database users only through roles

SANA: Both system and object level privileges can be provided to the database users through role or as individual privileges

RYAN: Since there are 10 users to be provided with same privileges it is optimal to provide the system and object privileges to the users, by assigning role granted with required privileges.

Which of the above statements are TRUE with respect to the scenario?

anonymous · Accepted Answer

Correct Solution - b

Important Links