Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 TDE Encryption

Author  Topic 

avijit_mca
Posting Yak Master

109 Posts

Posted - 2011-04-27 : 01:35:55
Hi,
I have applied TDE encryption in Databse level. But If i login database and write any select command .. i m able to find retrieve all the values. pls tell me how encryption is work in Database level.

Regards,
avijit

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-04-27 : 07:00:23
I think that is to be expected. The picture on this page sort of tells the story. http://sqlblog.com/blogs/michael_coles/archive/2010/03/08/t-sql-tuesday-004-why-doesn-t-tde-encrypt-my-filestream-data.aspx

If you prevent users from being able to see data in a table/column etc., you can deny permissions. http://msdn.microsoft.com/en-us/library/ms173724.aspx
Go to Top of Page
   

- Advertisement -