Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

emmablisa

Computer
Feb 16, 2018
1
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?

 
Replies continue below

Recommended for you

Have the DBA work on a test database with the same schema to get the command structure correct, then have someone else execute the commands on the real 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
Footwell%20Animation%20Tiny.gif
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor