SQL user creation

Hi Manu K U,

Following are the steps How to Create Login, User and Grant Permissions in SQL Server?

• Step-1: Create New Login

• Step-2: Create User

• Step-3: Assigning Permission to User

Step-1: Create New Login

Step-1.1: Create New Login

Step-1.2: Enter details to Create New Login

Step-1.3: Verify Created New Login

Step-1.4: OR Create New Login using T-SQL command

CREATE LOGIN MyLogin WITH PASSWORD = '987';

Step-2: Create User

Step-2.1: Create New User

Step-2.2: Enter details to Create New User

Step-2.3: Verify Created New User

Step-2.4: OR Create New User using T-SQL command

create user  for login 

create user Guru99 for login MyLogin

Step-3: Assigning Permission to User

Step-3.1: Open User Properties

Step-3.2: Update details in User Properties

Step-3.3: OR Grant Permissions using T-SQL command

use 
grant  on  to 

USE EDU_TSQL
GO

Grant select on Course to Guru99

Summary:

Glad to help! Please mark this answer as the accepted answer if it helped you out!

You can create a SQL user with the CREATE USER command, then assign permissions using GRANT. For example:

CREATE USER Manu IDENTIFIED BY 'password';
GRANT SELECT, INSERT ON mydb.* TO Manu;

This way the user is created and given only the permissions you allow.

SQL user creation and permissions vary slightly across systems, but the general flow is

• Create a user

• Grant required privileges

Create user: CREATE USER username IDENTIFIED BY 'password';

Grant permissions: GRANT SELECT, INSERT, UPDATE ON database_name.* TO username;

The exact syntax can vary slightly depending on the database system (MySQL, PostgreSQL, SQL Server, etc.), but the concept is the same.

It’s also recommended to follow the principle of least privilege—only grant the permissions that are actually needed.