Post reply

SQL 2000 equivalent script for this SQL 2005 script

  • December 17, 2008 at 7:19 am

    #216602

    Anyone have a trick up their sleeve that simulates this SQL 2005 only script on SQL 2000?

    USE [master]

    GO

    CREATE LOGIN [DOMAIN\Account] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    GO

    DENY CONNECT SQL TO [DOMAIN\Account]

    GO

    This specific account is part of an AD group that has permissions to the database, but I want to specifically deny access to this one account and this is the easiest (and most straightforward, imho) way to take care of this special case.

    Any and all suggestions are welcome.

    Thanks,

    John

  • December 17, 2008 at 8:16 am

    #913868

    try sp_revokelogin or sp_denylogin to prevent members of a group or account from logging in.


    Shamless self promotion - read my blog http://sirsql.net

  • December 17, 2008 at 8:59 am

    #913923

    sp_denylogin did the trick. I've been trying revoke, but that just removes the account entirely from the server. Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply