Re: Windows Services Groups

Thanks! I really appreciate the tips.

Hari

"DB2DOTNETCZAR via SQLMonster.com" wrote:

Hari,

I have copied the content for your convenience.

************************************************************************************************************************
sp_denylogin (T-SQL)

Prevents a Microsoft® Windows NT® user or group from connecting to Microsoft
SQL Server™.
Syntax

sp_denylogin [@loginame =] 'login'
Arguments

[@loginame =] 'login'
Is the name of the Windows NT user or group. login is sysname, with no
default. If the Windows NT user or group does not exist in SQL Server, it is
automatically added.

Return Code Values

0 (success) or 1 (failure)
Remarks

sp_denylogin can be used only with Windows NT accounts in the form Domain\
User, for example London\Joeb. sp_denylogin cannot be used with SQL Server
logins added with sp_addlogin.

Use sp_grantlogin to reverse the effects of sp_denylogin and allow the user
to connect.

sp_denylogin cannot be executed within a user-defined transaction.
Permissions

Only members of the securityadmin or sysadmin fixed server roles can execute
sp_denylogin.
Examples

This example prevents user Corporate\GeorgeW from logging in to SQL Server.

EXEC sp_denylogin 'Corporate\GeorgeW'



Or

EXEC sp_denylogin [Corporate\GeorgeW]


*************************************************************************************************************

Hope this helps :)

--
Best Regards

Anil Mahadev

http://anilm001.myfreewebs.net/index2.php

http://www.db2india.org

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/200609/1


.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • exec: Search order under Windows
    ... when I call a external executable via the exec command under Windows, ... that Tcl first searches in the directories listed in PATH? ... When attempting to execute an application, ...
    (comp.lang.tcl)
  • Re: exec: Search order under Windows
    ... command first. ... > when I call a external executable via the exec command under Windows, ... > When attempting to execute an application, ...
    (comp.lang.tcl)
  • Re: Permission for Importing data.
    ... database owner to execute xp_cmdshell. ... the SQL Server service is running. ... Microsoft® Windows NT® 4.0 and Windows 2000. ...
    (microsoft.public.sqlserver.dts)