How to create a user in MSDE?

[Terry Olsen]

I need to know how to create a user in MSDE. I can't seem to get the
syntax correct. I've tried several different variations such as the
following, but nothing seems to work.

CREATE USER user PASSWORD password
CREATE USER 'user' PASSWORD 'password'
CREATE USER user PASSWORD 'password'
CREATE USER user SET PASSWORD 'password'

Can't seem to find any references on google either. Can anyone help?

 

[Zoury]

Hi Terry ! :O)

Look at the sp_grantdbaccess stored procedure
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ga-gz_290z.asp

 

[Andrew D. Newbould]

I need to know how to create a user in MSDE. I can't seem to get the
syntax correct. I've tried several different variations such as the
following, but nothing seems to work.

CREATE USER user PASSWORD password
CREATE USER 'user' PASSWORD 'password'
CREATE USER user PASSWORD 'password'
CREATE USER user SET PASSWORD 'password'

Can't seem to find any references on google either. Can anyone help?

1. Use "sp_addlogin" to add your login id (must be attached to master
database.

2. Use "sp_grantdbaccess" to grant your new login access to your
database.

3. Use "sp_addrolemember" to grant your new login its permissions.

All explained in "Books OnLine" and can be called from OSQL.