DISABLE LOGIN - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

DISABLE LOGIN

Author

Topic

scottpt
Posting Yak Master

186 Posts

Posted - 2002-10-10 : 15:59:05

I want to be able to disable a login that uses SQL authentication. I do not want to change the PWD so I would like just to deny the user from being able to login. Has any one tried to do this. I am looking at messing with the xstatus column in sysxlogins to see if I can get it to work. Any comments would be helpful.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-10-10 : 16:03:38

DO NOT MODIFY THE SYSTEM TABLES DIRECTLY!!!!

You can use sp_denylogin to deny server access. See Books Online for more details.

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-10-11 : 07:12:48

Except sp_denylogin ony works for NT logins

You can either drop the login using sp_droplogin or change the password (effectively denying login) using sp_password. Never modify the system tables directly - always use the supplied system stored procedures !

HTH
Jasper Smith

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-10-11 : 10:55:43

quote:
Except sp_denylogin ony works for NT logins

Must. Read. More. Carefully.

Hang on, the coffee will kick in sooner or later...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources