Can a SQL Server DBA be restricted from viewing the information in the database?
Can a SQL Server DBA be restricted from viewing the information in the database.?
Because of some data privacy regulations, my company may need to have a SQL DBA work with things like mirroring, index rebuilds, log shipping, clustering general system maintenance things like that while not having access to view the information in the database tables.
This sounds impossible to me, but is it at all possible to give someone access to do anything with a database except view the data included?
If you're talking about the Operational DBA and not the Development DBA the answer is no. The Ops DBA has access to everything in the database, because they control the access. That being said they can grant rights to others that will allow them to do certain things with a database, but not read the data.