Skip to content

Instantly share code, notes, and snippets.

@coderdipto

coderdipto/create_user.sql

Created April 8, 2020 05:06
Show Gist options
  • Save coderdipto/86c24c985b49b3a9b23c8691b4ad2a29 to your computer and use it in GitHub Desktop.
Save coderdipto/86c24c985b49b3a9b23c8691b4ad2a29 to your computer and use it in GitHub Desktop.
Download ZIP
Create user SQL Server T-SQL
Raw
create_user.sql
-- Creates the login AbolrousHazem with password '340$Uuxwp7Mcxo7Khy'.
CREATE LOGIN sudipto
WITH PASSWORD = 'Root1234';
GO
-- Creates a database user for the login created above.
CREATE USER sudipto FOR LOGIN sudipto;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment