Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-27 : 07:44:21
|
| Gayathri writes "sir,I wanted to create user in sql server through queries as we are porting from oracle to sql server.I know that we can create user through enterprise manager but that solution is not required.Please help me by giving the query which will create the user.And is there any equivalent of oracle's tablespace in MSSqlServer.waiting for your reply.Please do help us.We are using MsSqlServer2000 and Windows version 2000,NT,XP and 2003" |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-27 : 09:20:30
|
| Use sp_GrantLogin to add Windows Authenticated users, or sp_AddLogin to add SQL Server logins. follow this up with sp_GrantDBAccess to give these logins access to databases.Raymond |
 |
|
|
|
|
|
Creation of User