Re: Protecting database

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 05/25/03 

Date: Sat, 24 May 2003 19:04:03 -0700

An administrator can always see everything, except for the definition of
encrypted stored procedures and functions. Data cannot be encrpted, nor can
the metadata.
In the current versions, the metadata is available to anyone who can cannot.
That may change in the next version, but the superpowers of the admin will
not change. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Johny" <goky2002@beograd.com> wrote in message
news:eqDNv9lIDHA.1732@TK2MSFTNGP11.phx.gbl...
> I want to install my database on SQL server. I want to protect it so that
> nobody can see the structure and the data(including administrator if it is
> possible).
>
> How can I do that?
>
>

Relevant Pages

  • Re: Permission question - another one
    ... I would have thought that Administrator ... Are you asking why is it connecting to SQL Server? ... > and I gave BUILTIN/Administrator this database as its default database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Windows Vista Enterprise and SQL Server 2005 Agent
    ... This has nothing to do with SQL Server and this is an expected behaviour of Windows Vista operating systems. ... Cause of those popups and normal-user-like acting is some new security system called User Account Control. ... It all seems to be related to security things, even though I am an administrator. ...
    (microsoft.public.sqlserver.security)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: BULK Insert Problem
    ... Vyas, MVP (SQL Server) ... I Log on to my system using the Local System Administrator Account. ... And If I Try to Bulk Insert any thing from my ...
    (microsoft.public.sqlserver.programming)
  • Re: Permission question - another one
    ... SQL Server looks at when you try to connect using Windows Authentication. ... >>> Does your Windows Login TRAVAC/tfs belong to the local Administrators ... >> Are you talking about on Raptor? ... > I am assuming local administrator is in local users and groups from ...
    (microsoft.public.sqlserver.programming)