i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases.
Method 1: T-SQL
CREATE LOGIN [test] WITH PASSWORD=N'test', DEFAULT_DATABASE=[xyz],
EXEC master..sp_addsrvrolemember @loginame = N'test', @rolename = N'sysadmin'
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
3 years ago