开发者

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

开发者 https://www.devze.com 2023-02-07 23:09 出处:网络
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 syste开发者_开发技巧m maintenance things l

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 syste开发者_开发技巧m 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?


DBAs (i.e.sysadmin or sa rights) have no restrictions on their activities.

So only if the data is stored encrypted from the client code. But what about client code developers, Windows admins, network admins, web server admins etc? And those pesky users with their USB pens.

0

精彩评论

暂无评论...
验证码 换一张
取 消