Post reply

Locking users out of a database

  • February 5, 2009 at 12:06 pm

    #206288

    I need to perform an upgrade and I need to keep our users from accessing the database at that time.

    If I right click on my database->click properties->then click options. I see information under State.

    Database(Read-only) false

    Restrict access - Multi-user

    Is this where I restrict users? Do I change false to true or change multi-user to restrict_user?

    Thanks for your assistance.

  • February 5, 2009 at 12:23 pm

    #939122

    I tried it out on my test database. I change multiuser to restricted_user and it worked.

  • February 5, 2009 at 1:38 pm

    #939171

    u can also use

    Alter database [database name] set single_user

    Alter database [database name] set multi_user

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • February 5, 2009 at 1:40 pm

    #939175

    Thanks.

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

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