Tag Info

New answers tagged

0

Connect to master database and do the following: CREATE LOGIN YourNewUser WITH PASSWORD = '<strong password here>'; Connect directly to database that the new user should own: CREATE USER YourNewUser FOR LOGIN YourNewUser; EXEC sp_addrolemember 'db_owner', 'YourNewUser';



Top 50 recent answers are included