Examice

Exam C2090-616 All QuestionsBrowse all questions from this exam

Question 20

What is the purpose of a role?

To define exactly what a specific user can and cannot do within a particular database once they have been authenticated

To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges

To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles

To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group

Correct Answer: C

The purpose of a role is to group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles. This simplifies the administration and management of privileges within a database system.

Discussion

Belusa_7Option: C

C is correct. A role is a database object that groups together one or more privileges and can be assigned to users, groups, PUBLIC, or other roles by using a GRANT statement, or can be assigned to a trusted context by using a CREATE TRUSTED CONTEXT or ALTER TRUSTED CONTEXT statement. https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0050531.html

db2testerOption: C

The answer A is wrong. The correct answer is C. Roles simplify the administration and management of privileges by offering an equivalent capability as groups but without the same restrictions. A role is a database object that groups together one or more privileges and can be assigned to users, groups, PUBLIC, or other roles by using a GRANT statement, or can be assigned to a trusted context by using a CREATE TRUSTED CONTEXT or ALTER TRUSTED CONTEXT statement. A role can be specified for the SESSION_USER ROLE connection attribute in a workload definition. Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.sec.doc/doc/c0050531.html