Re: Block Admin access to my data

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 07/26/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Fri, 26 Jul 2002 08:00:16 -0500

Sysadmin always has full control over all databases so you can't prevent
sysadmin access. If you are concerned about protecting your
intellectual property, I suggest your application include a binding
legal agreement which states what is not allowed, such as reverse
engineering. Basically, use the same technique that protects your code.

Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Mike" <mmcpheat@pdsint.com.au> wrote in message
news:xm709.6321$Cq.276409@ozemail.com.au...
> I have an application that I install on client's systems. I was
hoping to
> lock tham out of my database unless using a specific login. Since it
is on
> client system I have no control of SQL Server Administrator
privileges.
>
> I was hoping that I could create a login - then create my database
with that
> login or set the owner of my database to that login - then remove
privileges
> from administrator accounts to perform writes to my database. Even
better
> would be restriction of viewing data and schema information.
>
> I would like to lock down all administrator access on my database to
my
> login.
>
> Mike
>

Relevant Pages

  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)