Skip to main content

Can a SQL Server DBA be restricted from viewing the information in the database?

Last post 06:49 pm February 12, 2018 by Stephen Randolph
1 reply
07:41 am February 5, 2018

 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?


06:33 pm February 10, 2018

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.

By posting on our forums you are agreeing to our Terms of Use.

Please note that the first and last name from your member profile will be displayed next to any topic or comment you post on the forums. For privacy concerns, we cannot allow you to post email addresses. All user-submitted content on our Forums may be subject to deletion if it is found to be in violation of our Terms of Use. does not endorse user-submitted content or the content of links to any third-party websites.

Terms of Use may, at its discretion, remove any post that it deems unsuitable for these forums. Unsuitable post content includes, but is not limited to, Professional-level assessment questions and answers, profanity, insults, racism or sexually explicit content. Using our forum as a platform for the marketing and solicitation of products or services is also prohibited. Forum members who post content deemed unsuitable by may have their access revoked at any time, without warning. may, but is not obliged to, monitor submissions.