create a user in a database

Posted by Professionaluser under Sql Server category on | Points: 40 | Views : 160
ABC( the login account which created in previous Codes section) now has access to the instance of SQL Server, but does not have permission to access the databases. This user does not even have access to her default database TestData until you authorize him/her as a database user.

So we need to create a user for that login account,
USE [TestData];

CREATE USER [ABC ] FOR LOGIN [computer_name\ABC ];

Comments or Responses

Login to post response