Re: Database protection

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 09/15/05

  • Next message: Meenal Dhody: "Database roles" 
    Date: Thu, 15 Sep 2005 13:48:07 +0100

    Hi

    Have you looked at sp_revokedbaccess?

    John

    "Rene" <nospam@nospam.com> wrote in message
    news:uwzGIpbuFHA.2072@TK2MSFTNGP14.phx.gbl...
    > Is there a way to prevent users from logging into an MSDE database
    > instance? I created an MSDE instance using a strong SA password but I was
    > still able to logging to the database using Windows Authentication.
    >
    > The reason I don't want the user to see the database is because the
    > database structure that I am distributing (MSDE) is exactly the same as
    > the one I have online. If I let the user peek into my MSDE database they
    > might find a way to mess-up the database that is online. I just don't want
    > to take the risk.
    >
    > Also, is stored procedure encryption easily bypassed if I logon as a
    > database administrator?
    >
    > Thanks.
    >
    >

  • Next message: Meenal Dhody: "Database roles"

    Relevant Pages