| Author |
how could i hide my finacial data to sa when i store them in sql server 2k?
|
|
|
| what we store in db is informatin about company finacial status.
we don't want anyone in charge of the server can read the those data.
what can i do without 3rd party software like activecrypt?
thank you.
| |
| Jasper Smith 2005-09-06, 3:23 am |
| You can't prevent a member of the sysadmin role in SQL Server (like sa) from
viewing data so you would need to encrypt it either before storing it in SQL
or use a third party product
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"xuyan" <microsoft.net@sina.com> wrote in message
news:eRfUysosFHA.3404@TK2MSFTNGP09.phx.gbl...
> what we store in db is informatin about company finacial status.
> we don't want anyone in charge of the server can read the those data.
> what can i do without 3rd party software like activecrypt?
>
> thank you.
>
>
| |
| Uri Dimant 2005-09-06, 3:23 am |
| Hi
Where does the info reside? One or many tables?
You can adde the user to db_denydatareader role and make sure that he/she is
not a member of sysadmin server role.
"xuyan" <microsoft.net@sina.com> wrote in message
news:eRfUysosFHA.3404@TK2MSFTNGP09.phx.gbl...
> what we store in db is informatin about company finacial status.
> we don't want anyone in charge of the server can read the those data.
> what can i do without 3rd party software like activecrypt?
>
> thank you.
>
>
|
|
|
|