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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-08-21 : 09:51:24
|
| I am not able to DENY access for a SQL LOGIN by sp_denylogin. Is there a way to do this?I was thining of simply changing the password!------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 11:28:20
|
| sp_denylogin 'domain\username'See 'ALter login' in Books online |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-21 : 11:33:36
|
quote:
Originally posted by sodeep
sp_denylogin 'domain\username'
I am NOT talking about domain users! I am talking about SQL LOGINS.------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 11:38:10
|
| Ok so you deleted your other post. You were stating about groups ,that why i gave that answer.For SQL Logins,Go to security,Right click that SQL login,Properties- status-Deny.Done. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-21 : 11:46:55
|
quote:
Originally posted by sodeep
Ok so you deleted your other post. You were stating about groups ,that why i gave that answer.
I am rephrasing the question, here it is. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109259quote:
For SQL Logins,Go to security,Right click that SQL login,Properties- status-Deny.Done.
This option is not there for SQL2K sql logins!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
sp_denylogin in SQL2K