MSSQLTips

This post is related to this tip: Database level permissions for SQL Server 2005 and 2008

http://www.mssqltips.com/tip.asp?tip=1718

I grant database permissions to new database roles I create. Then I assign logins to this new database role. The database role names all begin with "permission_" so they are groups together and I can differentiate them between system databases roles and roles I created.