February 12, 2015 at 8:39 am
My Client does not want DBA to view user tables/Data in Sql server database on every instances but can do all SQL administration task like Backup/Restore,Database maintenance ,SqlAgent Jobs,Index maintenance,sql Cluster administartion.That is DBA having all DB administration rights but cannot view user data as the data belongs to customer.SQL server 2005-2008 available in client environment.Let us know any possibility and how this can be reached in such environment.
Regards
Rishi
February 12, 2015 at 8:43 am
Not possible. Suggest to them that they encrypt, in the application, any data that they don't want the DBA to see.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply