What are database roles?

What are database roles?

Rating:

Roles are similar to groups in Windows. Roles help in managing users by grouping them as a single unit. Permissions granted to, denied to, or revoked from a role also apply to members of the role. Therefore, adding a user to a role enables permissions to be easily granted or denied to the user. Microsoft recommends creating roles based on job functions and assigning each role the permissions that apply to that particular job. This simplifies user administration, as the permissions do not have to be managed for each individual user. If the function of a job changes, it becomes easier to simply change the permissions once for the role and have the changes applied automatically to all the members of the role.

Rating: