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 |
|
zaidqis
Yak Posting Veteran
63 Posts |
 Posted - 2006-06-10 : 12:41:58
|
| hican you tell me how to creat users in MS SQL Server 2005 ??i tried but i cannot..my server name is : TOOLSBOX\SQLEXPRESScan you guide me to lesson or book talking about how to creat users ??and can you guide me to book talking about how to creat users and roles ... etcthank you |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-10 : 14:17:40
|
| http://msdn2.microsoft.com/en-us/library/ms173463.aspx==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
zaidqis
Yak Posting Veteran
63 Posts |
Posted - 2006-06-10 : 14:41:57
|
| thank youcan you tell me how to do it using Management StudioThank you |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-10 : 14:57:58
|
| in left frame expand security, right click on logins, new loginin database - expand security, right click on users, new userdouble click on login, user mapping - associate with user in databasein database, security right click on roles - new role.Then add user to role.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Users !!