Export securables from SQL Server 2005 or higher.

Brian Kelley wanted something to store role security for disaster recovery. It came in very handy to get the permissions used on a development system into a live system.

Since I was only worried about a single role, I added the condition “AND dprins.name = @RoleName” at the end.

Leave a Reply