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.

Improve this question

1 Answer 1

Reset to default
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?

Improve this answer
2
  • Thanks. For encryption, it will make string searches, especially regex, on database strings impossible I thought.
    – sOltan
    Jun 7, 2014 at 1: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, 2014 at 20:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .