creating an user ???

[kindus]

How do I create an user in SQL server? I could not find any command to create an user, nearest is creating a schema.

Please Ctrl F1!!

 

[rlwan]

Use Enterprise Manager - security folder

 

[Databaseguy]

Do you want to do this from the Query Designer or from the MMC ?

 

[kindus]

I would like to execute it from osql prompt just like I do in oracle.

thanks

 

[Databaseguy]

I'm fairly new. Coming across from an Access background. Have you tried
sp_grantdbaccess [@loginame =] 'login'
[,[@name_in_db =] 'name_in_db' [OUTPUT]]

 

[tlbroadbent]

You need to create a SQL Server login first.

Add login for SQL authentication
sp_addlogin [@loginame =] 'login'
[,[@passwd =] 'password']
[,[@defdb =] 'database']
[,[@deflanguage =] 'language']
[,[@sid =] 'sid']
[,[@encryptopt =] 'encryption_option']

Add login for NT authentication
sp_grantlogin [@loginame =] 'login'

Create a user in each database you want the login to access.

sp_grantdbaccess [@loginame =] 'login'
[,[@name_in_db =] 'name_in_db' [OUTPUT]]

name_in_db is commonly called the user.

You can accomplish the same in Enterprise manager (EM). Look under Server Security. Right click logins. Select New Login. Type in a name. Select databses you want the login to access. Select a default database. Set server roles if appropriate.

I prefer to use EM to administer security. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.