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 |
|
real_pearl
Posting Yak Master
106 Posts |
 Posted - 2004-10-20 : 02:28:26
|
| I want to know how can we create login and assign priviliges? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-20 : 03:54:41
|
| check BOL for sp_addlogin, sp_grantlogin, sp_defaultdb,permissions--------------------keeping it simple... |
 |
|
|
chetancool
Starting Member
34 Posts |
Posted - 2004-10-21 : 07:33:28
|
| There are in-built store procdeure for this work :sp_addlogin - for adding usersp_revokelogin - for removing usersp_defaultdb - for giving user a default db when he logs insp_grantlogin - Giving rights of login to usersp_denylogin - revoking login rights from usersp_droplogin - for dropping login acsp_password - to change the passwordcjain |
|
|
|
|
|
|
How to create Login through T-SQL