Re: Set Restricted_User

From: Eric (Eric_at_discussions.microsoft.com)
Date: 11/11/04

  • Next message: Sue Hoegemeier: "Re: Set Restricted_User" 
    Date: Wed, 10 Nov 2004 15:04:03 -0800

    Hi Sue,

    I' not getting any error per se but rather undesirable results by running
    Alter Database with Set Restricted_User.

    When I run this command:

    Alter Database dbname Set Restricted_User With Rollback Immediate

    it logs off everyone including sysadmins and db_owners. Is there a way to
    log out everyone except sysadmins and or db_owners?

    Cheers
    Eric

    "Sue Hoegemeier" wrote:

    > And the difficulty you are having is what exactly? What is
    > the error? Does the database go into restricted_user mode?
    > Are you closing the connection after you execute the
    > statement?
    > On a side note, if you are doing this with an login that is
    > a sysadmin, you don't need to add that login to db_owners.
    > Sysadmins can access a database that is in restricted_user
    > mode.
    >
    > -Sue
    >
    > On Tue, 9 Nov 2004 19:52:01 -0800, "Eric"
    > <Eric@discussions.microsoft.com> wrote:
    >
    > >Hi there,
    > >
    > >I'm having difficulty trying to lock a databse so as to prevent people from
    > >logging in, and at the same time, not logging myself out. The following
    > >statement allows me to lock the db, however, it also logs me out at the same
    > >time.
    > >
    > >Alter Database dbname Set Restricted_User With Rollback Immediate
    > >
    > >I have created a separate executable through VB that locks and unlocks, and
    > >is executed from within another application. This application uses the SQL
    > >Server as the backend. I need to log into the application first using a
    > >system admin account that also has db_owner rights, and then perform locking,
    > >and still remain logged into the db.
    > >
    > >Using the statement above, the db_owner will still have access to the db,
    > >but how do I ensure that the statement does not log me out as soon as I
    > >execute it?
    > >
    >
    >

  • Next message: Sue Hoegemeier: "Re: Set Restricted_User"

    Relevant Pages

    • Re: Keeping users out while updating data
      ... Alter database northwind set RESTRICTED_USER with rollback immediate ... >> I try to open query analyzer to execute my stored proc it won't let me ...
      (microsoft.public.sqlserver.server)
    • Re: Sql Server Mode
      ... > can i change the mode to full acces also i am using ... ALTER DATABASE dbname SET READ_WRITE ...
      (microsoft.public.sqlserver.security)
    • Re: Set Restricted_User
      ... Alter database dbName set single_user with rollback immediate ... > Alter Database dbname Set Restricted_User With Rollback Immediate ...
      (microsoft.public.sqlserver.security)