URGENT database security question

[Praim Sankar]

We have a requirement to secure the data in a new database so that no
one can look at all of the data, including the SA / dbo.

Should we give the VP the sa password and tell her how to change it so
even the DBA can't access the data?

Can we somehow stop SA/dbo from looking at say , a salary column, in a
table?
I know I can do it for oth users but can it be done for sa??

Thanks

praim sankar

[Leythos]

In article <32*************************@posting.google.com> ,
pr**************@cogeco.com says...

We have a requirement to secure the data in a new database so that no
one can look at all of the data, including the SA / dbo.

Should we give the VP the sa password and tell her how to change it so
even the DBA can't access the data?

Can we somehow stop SA/dbo from looking at say , a salary column, in a
table?
I know I can do it for oth users but can it be done for sa??

SA Owns the server and data, you can not limit SA for long.

Why didn't you encrypt the data you don't want people to see?

--
--
sp*********@rrohio.com
(Remove 999 to reply to me)