When should you create a role? (Choose two)

Question

Options

• ATo simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by
• BTo grant a group of related privileges to a user.
• CWhen the number of people using the database is very high.
• DTo simplify the process of granting and revoking privileges.
• ETo simplify profile maintenance for a user who is constantly traveling.

• A
  4% (1)
• B
  17% (4)
• C
  71% (17)
• E
  8% (2)

Explanation

You should use roles to grant a group of privileges to a user. You grant the appropriate privileges to the role and after that grant this role to specific users. By granting to or revoking privileges from the role you can simplify procedure of users privileges maintainance: you don't need to grant/revoke privileges to/from each user. It's especially very helpful when you are experiencing a high number of people using the database. Incorrect Answers A: Roles have nothing to do with simplifying the process of creating new users. B: You can use roles to grant a group of privileges to a user, but they can be not related at all. E: Roles have nothing to do with user who is constantly traveling.

No community discussion yet for this question.