What are the use of Roles?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

211. What are the use of Roles?

REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges for a group of related users granted to a role and then grant only the role to each member of the group. DYNAMIC PRIVILEGE MANAGEMENT - When the privileges of a group must change, only the privileges of the role need to be modified. The security domains of all users granted the group’s role automatically reflect the changes made to the role. SELECTIVE AVAILABILITY OF PRIVILEGES - The roles granted to a user can be selectively enable (available for use) or disabled (not available for use). This allows specific control of a user’s privileges in any given situation. APPLICATION AWARENESS - A database application can be designed to automatically enable and disable selective roles when a user attempts to use the application.

(Continued on next question...)

Other Job Interview Questions

• If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
• A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
• How do you display console on a window?
• What is a deadlock?
• Explain UNION, MINUS, UNION ALL and INTERSECT?
• What are the Coordination Properties in a Master-Detail relationship?
• What column differentiates the V$ views to the GV$ views and how?
• How can values be passed between precompiler exits & Oracle call interface?
• What are different types of images?
• What is a Schema?
• More...