Roles

Roles

In SQL Server 2008, roles are used to manage and assign permissions to database objects. Roles provide a way to simplify the management of permissions by grouping users or other roles together and then assigning permissions to the group.

There are three types of roles in SQL Server 2008:

1. Server roles: These roles are associated with the server and provide administrative privileges to the members of the role. Examples of server roles include sysadmin, securityadmin, and setupadmin.
2. Database roles: These roles are associated with a specific database and provide permissions to the members of the role for objects within the database. Examples of database roles include db_owner, db_datareader, and db_datawriter.
3. Application roles: These roles are created specifically for an application and provide permissions to the application, rather than to a user or group. Application roles are activated through an application code and can be used to restrict access to sensitive data.

By using roles, administrators can manage permissions more efficiently by assigning permissions to roles instead of individual users. This simplifies the management of permissions and reduces the risk of errors and inconsistencies.

Apply for SQL Server 2008 Certification!!

https://www.vskills.in/certification/certified-sql-server-2008-programmer

Back to Tutorials