SQL user creation

Question

SQL user creation and permission

Niharika Gupta · Answer

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.

Pankajkumar Patel · Answer

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: Step-1: Create New Login Step-2: Create User Step-3: Assigning Permission to User Step-1.1: Create New Login Step-2.1: Create New User Step-3.1: Open User Properties Step-1.2: Enter details to Create New Login Step-2.2: Enter details to Create New User Step-3.2: Update details in User Properties Step-1.3: Verify Created New Login Step-2.3: Verify Created New User Step-3.3: OR Grant Permissions using T-SQL command Step-1.4: OR Create New Login using T-SQL command Step-2.4: OR Create New User using T-SQL command Glad to help! Please mark this answer as the accepted answer if it helped you out!

Cynthia Sathuragiri · Answer

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.

SQL user creation

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)