Encrypt whole database in Sql 2005 Express?

Hello
Is it posible to encrypt whole database in Sql 2005 Express. I need it for
deployment process of my application and hiding database structure?
Or if not is good solution to use third party software for this propose?
Thank you
MilanB
The easiest way to encrypt a whole database is to put it in an encrypted
NTFS directory. That has some performance implications obviously and may or
may not do what you want it to depending on who you want to hide the data
from.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"MilanB" <MilanB@.discussions.microsoft.com> wrote in message
news:B52AF8B2-F961-4436-99A4-DD27DB353168@.microsoft.com...
> Hello
> Is it posible to encrypt whole database in Sql 2005 Express. I need it for
> deployment process of my application and hiding database structure?
> Or if not is good solution to use third party software for this propose?
> Thank you
> MilanB
|||hi,
MilanB wrote:
> Hello
> Is it posible to encrypt whole database in Sql 2005 Express. I need
> it for deployment process of my application and hiding database
> structure?
> Or if not is good solution to use third party software for this
> propose?
regarding "hiding database structure", you can perhaps deny VIEW DEFINITION
permissions
http://msdn2.microsoft.com/en-us/library/ms175808.aspx and
http://msdn2.microsoft.com/en-us/library/ms187113(en-us,VS.90).aspx , even
at the database "securable" level..
the other traditional permission (SELECT/INSERT/UPDATE/DELETE/EXEC) should
be managed as well as in any security concerned scenario... drop the "Guest"
database user and define an appropriate object access policy..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply