From: web12master@gmail.com
Thanks for you answer.
Regards
"Erland Sommarskog" wrote in message
news:Xns9E7762BD2621FYazorman@127.0.0.1...
>m (web12master@gmail.com) writes:
>> from application owner point of view, there is an issue to protect
>> database logic and structure from stealing.
>>
>> I'm pretty sure that was impossible to do (at least not easy to do) on
>> MSSQL2000 and MSSQL2005, but what about MSSQL2008?
>>
>> MSSQL2008 has possibilty of transparent encryption backup so backup
>> could be protected very efficiently, what about database structure and
>> logic, is it possible to hide it from sql system admin?
>
> You can never hide anything from a system admin.
>
> The point with TDE is to protect data at rest. If someone manages to get
> hold of the database files or database backup without having the
> encryption
> key, he is not able to access the data.
>
> But if the user is able to connect to the server and has permissions
> enough,
> he can also see tables and procedures. And someone on the server needs to
> have that protection.
>
> It also worth pointing out that TDE is only available in Enterprise
> Edition.
>
> The proper way to protect intellectual property is through license
> agreements.
>
> The only possible solution from a technical point of view is to host the
> application yourself - which of course is an immense investment.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
