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?
(OP)
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 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?
Because of some data privacy regulations, my company may need to have a 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?





RE: Can a SQL Server DBA be restricted from viewing the information in the database?
"Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database."
https://technet.microsoft.com/en-us/library/ms1879...
https://social.msdn.microsoft.com/Forums/sqlserver...
RE: Can a SQL Server DBA be restricted from viewing the information in the database?
Though having a DBA who is never allowed to look at the DB they're working on seems a bit short-sighted.
Dan - Owner
http://www.Hi-TecDesigns.com