Re: Protecting database

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

  • Next message: Jasper Smith: "Re: Linked Servers - setspn - domain account" 
    Date: Sat, 24 May 2003 19:13:35 -0700

    Oops, I meant the metadata is available to anyone who can connect! 

    --
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:OUT0YHmIDHA.2256@TK2MSFTNGP11.phx.gbl...
> 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?
> >
> >
>
>
  • Next message: Jasper Smith: "Re: Linked Servers - setspn - domain account"

    Relevant Pages

    • Re: waitresource
      ... SQL Server MVP ... > Also on lock escalation, i think in your Inside SQL server 2000, you ... >> Kalen Delaney ... >> SQL Server MVP ...
      (microsoft.public.sqlserver.server)
    • Re: PAE VS SQL Server AWE
      ... "Mike Epprecht " wrote in message ... > Mike Epprecht, Microsoft SQL Server MVP ... >> Kalen Delaney:-P) that when you shrink the kernel mode address space ...
      (microsoft.public.sqlserver.server)
    • Re: Force 0?
      ... > Pro SQL Server 2000 Database Design ... >> If that is the case, try using GROUP BY ALL MSNumber ... >> Kalen Delaney ... >> SQL Server MVP ...
      (microsoft.public.sqlserver.programming)
    • Re: Can view accept parameters
      ... Tibor Karaszi, SQL Server MVP ... >>Kalen Delaney ... >>> thks & rdgs ...
      (microsoft.public.sqlserver.server)
    • Re: "EXEC" in SQL Server 2000 Views
      ... Kalen Delaney ... > INNER JOIN b ... > Could not execute query against OLE DB provider 'MSDASQL'. ... >> SQL Server MVP ...
      (microsoft.public.sqlserver.programming)