Query to Create a UserRSS

• • Reply
  Gowtham Jais...

  None

  0 Points

  2 Posts

  Query to Create a User

  Oct 18, 2019 01:24 PM|Gowtham Jaisankar|LINK

  Hi All,

  What is the T-SQL Query to create a new user and how to give access in T-SQL

• • Reply
  PatriceSc

  All-Star

  45720 Points

  16619 Posts

  Re: Query to Create a User

  Oct 18, 2019 05:12 PM|PatriceSc|LINK

  Hi,

  Seems you are looking for https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-ver15

  You could then add this user to the db_datareader/db_datawriter roles:

  https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15

  You create a user so that your web app can read and write to the application db ? Some more context could perhaps help to better understand which level of information you need.

• • Reply
  Yang Shen

  Participant

  1700 Points

  531 Posts

  Re: Query to Create a User

  Oct 21, 2019 09:10 AM|Yang Shen|LINK

  Hi Gowtham,

  Gowtham Jaisankar

  What is the T-SQL Query to create a new user

  You can refer to SQL Server Script to create a new user, the query should be like below:

  CREATE LOGIN NewUserName WITH PASSWORD = 'password'
  GO

  Gowtham Jaisankar

  how to give access in T-SQL

  Maybe you could try the GRANT method in sql server which you can refer to Granting table level permissions in SQL Server for how to use it.

  GRANT SELECT ON "dbo"."DatabaseName" TO "UserName"`

  Hope this could help.

  Best Regard,

  Yang Shen