Post reply

SQL 2000 disable login

  • April 28, 2009 at 1:43 pm

    #95128

    Is it possible to disable a sql login in sql 2000? Please advise.

    ¤ §unshine ¤

  • April 28, 2009 at 2:22 pm

    #985473

    I think the closest you could get to that would be to change the password so the login would fail. It begs the question though, why you want to disable it rather than delete it. Do want to temporarily prevent the login from accessing SQL?

    Greg

  • April 28, 2009 at 2:33 pm

    #985483

    Yes. It is to give access once a month.

    ¤ §unshine ¤

  • April 28, 2009 at 4:16 pm

    #985556

    You could script out the permissions and create 2 jobs. 1 job to create the login and grant db access and another job to drop the login. This assumes access is needed during the same dates of the month.

  • April 29, 2009 at 6:30 am

    #985836

    Good idea. thanks!

    ¤ §unshine ¤

Viewing 5 posts - 1 through 5 (of 5 total)

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