Multiple choice technology databases

When should you create a role? (Choose two)

  1. To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement

  2. To grant a group of related privileges to a user

  3. When the number of people using the database is very high

  4. To simplify the process of granting and revoking privileges
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Roles simplify privilege management by grouping related privileges together, making it easier to grant and revoke permissions for multiple users. This is especially valuable when many users need similar access patterns.

Keep practicing — related questions