Grant permissions to database users in SQL Server

 In SQL Server, a database role is a group of users that have a common set of permissions within a specific database. There are several predefined database roles in SQL Server, including db_datareader, db_datawriter, db_owner, and others. Each role has a specific set of permissions that allow users to perform different tasks within the database.

To grant permissions to database users, you can use the following steps:

1. Connect to the database using SQL Server Management Studio or another client tool.

2. Execute the following T-SQL code to grant specific permissions to a user:

                GRANT [permission] TO [username];

3. Replace [permission] with the specific permission you want to grant, such as SELECT, UPDATE, or DELETE, and [username] with the name of the user you want to grant the permission to.

4. For example, to grant the SELECT permission to the user Harsh, execute the following T-SQL code:

                GRANT SELECT TO Harsh;

5. If you want to grant permissions to a group of users, you can create a database role and add the users to that role. To create a database role, execute the following T-SQL code:

                CREATE ROLE [rolename];

6. Replace [rolename] with the name of the role you want to create.

7. To add users to a role, execute the following T-SQL code:

                EXEC sp_addrolemember '[rolename]', '[username]';

8. Replace [rolename] with the name of the role you want to add the user to, and [username] with the name of the user you want to add to the role.

By using database role memberships and granting permissions to database users, you can control access to your database and ensure that users only have the necessary permissions to perform their job functions.