Monday, February 20, 2012

Preventing access to DataBase & encrypt meta-data and data of tables

How can I encrypt Sql Server table meta-data (table name,column
name,releations and so on...)
I can encrypt Sql server stored-procedure,view... but I can not enrypt
the meta-data of data table! I do not want Sql Administrator to read
myDatabase's tables,releations,column names,actually I do not want to
open any tables
How can I do that?
Thanks !Oney
I am afraid you cannot do that.
But permit me ask you , why do you need to hide your data from DBA?
"Oney" <ozcankanbur@.yahoo.com> wrote in message
news:cc5e237f.0405232338.551596e0@.posting.google.com...
> How can I encrypt Sql Server table meta-data (table name,column
> name,releations and so on...)
> I can encrypt Sql server stored-procedure,view... but I can not enrypt
> the meta-data of data table! I do not want Sql Administrator to read
> myDatabase's tables,releations,column names,actually I do not want to
> open any tables
> How can I do that?
> Thanks !|||Hi,
DBA is the person who secure and protect your database, so hiding
information from him is too difficult and not good.
As far as I know there is not tool to encrypt the Tables , constraints and
Indexes.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ekjSISWQEHA.2248@.TK2MSFTNGP12.phx.gbl...
> Oney
> I am afraid you cannot do that.
> But permit me ask you , why do you need to hide your data from DBA?
> "Oney" <ozcankanbur@.yahoo.com> wrote in message
> news:cc5e237f.0405232338.551596e0@.posting.google.com...
> > How can I encrypt Sql Server table meta-data (table name,column
> > name,releations and so on...)
> >
> > I can encrypt Sql server stored-procedure,view... but I can not enrypt
> > the meta-data of data table! I do not want Sql Administrator to read
> > myDatabase's tables,releations,column names,actually I do not want to
> > open any tables
> >
> > How can I do that?
> >
> > Thanks !
>

No comments:

Post a Comment