Procedure to Assign Permissions/Roles in SQL Server

Using SQL Server, roles can be granted from the Logins node of the Microsoft SQL Server Management Studio.

Right-click on Logins and click New Login. This will open the screen, in which the System Administrator can create user logins and assign permissions/rights.

Users can have either Windows authentication or SQL authentication.

Once a user is created, access permissions for that user can be granted using:

1. Server Roles.

   for example, server-wide security privileges:

   

2. User Mapping.

   for example, database level security privileges.