[Go] CREATE database user

Use   



EXEC   sp_addlogin   
EXEC   sp_grantdbaccess   
EXEC   sp_addrolemember   N ' db_owner ',   


Go

Ask

n in SQL to get rid of it, so that users can not create, login issues

Reply

You can do it without going, directly in the Query Analyzer.

Comments | 0 0 2011-09-26 12:51wangzhiqing999 | level 15

--Create a database test123

Create DATABASE test123

Go

--Create login user test12345

CREATE LOGIN test12345

With password= ' Test ',

Default_database=[test123],

default_language=[Simplified Chinese],

Check_expiration=off,

Check_policy=off

GO

--Creating a database user (create user)

Use [test123]

GO

The database context has been changed to ' test123 '.

CREATE USER [test12345] for LOGIN [test12345] with default_schema=[dbo]

GO

exec sp_addrolemember ' db_owner ', ' test12345 '

GO