Sunday, February 19, 2012

How to i hide my database schema from...

everybody except 1 login which is non-sa in sql server 2000.
Even sa should not be able to access the schema.
Also are there anyways encrypt data in sql server 2000w
Anyone who has access to the database has access to examine, but not
necessarily modify, the schema.
If you Google for encryption and SQL Server you should find a couple of
hits. I assume that you want the data encrypted in the database.
If you mean the files themselves, an alternative is to use NTFS encryption
on the files.
Russell Fields
"w" <wilcorning@.hotmail.com> wrote in message
news:6a24cdf7.0402261134.be0b6ca@.posting.google.com...
> everybody except 1 login which is non-sa in sql server 2000.
> Even sa should not be able to access the schema.
> Also are there anyways encrypt data in sql server 2000

No comments:

Post a Comment