Block Admin access to my data

From: SQLSkip (sqlskip@hotmail.com)
Date: 07/26/02 

From: "SQLSkip" <sqlskip@hotmail.com>
Date: Thu, 25 Jul 2002 23:56:01 -0700

SA is essentially God when it comes to a database
server. It really depends on how much you are looking to
restrict here. One option is to encrypt your data but
that currently requires using a third party product.

There are lots of opinions regarding this but I feel very
strongly that if you cannot trust your administrator you
have other problems. I would maybe try to focus on
restricting who has administrator privs on the server.

SQLSkip

>-----Original Message-----
>I want my application to use a specific role/login to
access my database.
>
>Can I stop other users with Administrator privileges
from accessing the data
>in this database?
>
>-Mike
>
>
>.
>

Relevant Pages

  • Re: SharePoint Portal search is not working after changing admin paasw
    ... Just a thought but it could be the access account to the actual SQL server. ... Query on SQL and see if it lets you in as the Administrator. ... > Verified Password for services on our Database Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Cant create ADP database on MSDE using MS Access
    ... but no database is created and I ... > I've tried the SQL Server group but they can't solve it. ... > potential requirement for named pipes if Windows Authentication is to ... "Administrator" and "SA" are still 2 different ...
    (microsoft.public.access.setupconfig)
  • RE: No search results from non-portal content
    ... Central Administration and under Server Configuration, ... Have the customer add a user account with Local Administrator ... Roles Tab check off Systems Administrator, Security Administrator, Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SharePoint Portal search is not working after changing admin p
    ... as if it was now a ghost index server. ... >> Query on SQL and see if it lets you in as the Administrator. ... >> UK Sharepoint Training ... >>> Verified Password for services on our Database Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SharePoint Portal search is not working after changing admin p
    ... I am able to access SQL. ... was thinking of removing my current server as the job server since that will ... > Query on SQL and see if it lets you in as the Administrator. ... >> Verified Password for services on our Database Server ...
    (microsoft.public.sharepoint.portalserver)
Loading