Which role permits users to create new users within a database?

Disable ads (and more) with a premium pass for a one time $4.99 payment

Prepare for the Microsoft Certified: Azure Database Administrator Associate (DP-300) exam with flashcards and multiple choice questions, complete with hints and explanations. Get exam-ready today!

The role that permits users to create new users within a database is the Access admin. This role is specifically designed to manage access to the database by adding and configuring user accounts. Users with Access admin privileges can create, alter, and delete database users, and they can also assign roles and permissions to those users. This level of control is essential for maintaining database security and ensuring that only authorized individuals have access to sensitive data.

In contrast, the database owner has full control over all aspects of the database but does not specifically focus on user management as a primary function. The public role is a default role that includes all database users, but it does not grant the ability to create users. The schema owner is responsible for managing and owning database schemas, including the objects within them, but this role also does not encompass user creation capabilities. Therefore, the Access admin role is the most appropriate for granting user creation permissions within the database.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy