0

Is it possible on SQL Server Enterprise to hide a specific table partition from users including admins? encrypting the data is not an option for us.

sOltan
  • 163
  • 7

1 Answers1

0

No, you can't get more granular than the table level security. And there's definitely nothing you can hide from sysadmins (or even dbo within the same db) short of encrypting the data.

Why is encryption not an option? If you can't do it at the SQL level, can you do it within the app?

squillman
  • 37,883
  • 12
  • 92
  • 146
  • Thanks. For encryption, it will make string searches, especially regex, on database strings impossible I thought. – sOltan Jun 07 '14 at 01:02
  • Depends on how you do the encryption and how you want to search. If you encrypt from the SQL Server side they you will be able to decrypt to do your searches, given the appropriate keys of course. – squillman Jun 11 '14 at 20:32