In the first two installments of my articles on SQL Server security, I described server level roles and flexible database-level roles. This final article talks about row-based security, specifically row-based security using stored procedures.
Why would you want to use row-based security? Well, there are a lot of situations where you simply can’t use flexible roles [...]
I have to run similar code on a regular basis, so I thought I would share it with everyone.
Basically, it grants access on every stored procedure that meets a certain naming pattern to a single user.
– I’ve updated this with Aaron Bertrand’s suggestions from the comments.
– Thanks to Aaron for helping make this better!
DECLARE @sql [...]
This is following up from my previous post on Database Roles. In my previous post, I talked about fixed database roles. If you’ve forgotten, go back and re-read the article. I’ll still be here when you get back.
So, what exactly are flexible database roles? They are roles that you create in the database. It’s as [...]
Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level. If you are familiar with any aspect of system administration, database roles are similar to groups in the world of Windows system administration. Just like a Windows group, when a user is [...]