Post reply

Lock out users from database

  • March 14, 2008 at 1:47 am

    #71284

    Hi there,

    We are migrating one of our systems to 2005. The DBA is required to lock out all users from the database. How do I go about this?

    Regards

    IC

  • March 14, 2008 at 7:39 am

    #789624

    I suppose you want to lockout all users execpt the DBA.

    ALTER DATABASE myDB

    SET RESTRICTED_USER

    WITH ROLBACK IMMEDIATE

    The last line will rollback all open connections by non admin users. Only sysadmins and db_owner will be able to access the database.

    [font="Verdana"]Markus Bohse[/font]

  • March 14, 2008 at 7:49 am

    #789631

    Thanks so much!!!

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

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