What roles for ROLES?

[b]Koconnor?s [/b]question in the TechRepublic Discussion Center applies to Builder too.

https://www.techrepublic.com.com/5208-6230-0.html?forumID=7&threadID=152642&start=0

Keeping privileged users out of specific areas of data can be quite a hot topic. For data stored INSIDE a database, ROLES can play an important part in keeping people from accessing data they should not be seeing. This can include the DBA themselves!

While signed policies are never a bad idea, it is better to prevent the problem in the first place by denying access unless needed. Now would be a good time to review Susan Harkins? article on Understanding Roles in SQL Server.

https://www.techrepublic.com.com/5100-6329-1061781-1.html

[b]Koconnor asks: Does anyone have a policy statement for IT staff that tells IT staff about how it can and cannot make access data it is entrusted with?[/b]