Reset role permissions


  • Greetings all,

    While attempting to blaze a trail into the finer points of SQL Server 2008 security, I fear that I may have been too aggressive in trying to implement least privilege. I hate to impose, but my searchs through this forum and Google have been less than fruitful on finding an elegant way to reset the permissions on server roles to out-of-the-box defaults, in particular, the 'public' role.  Does anyone have a suggestion?  Also, there seem to be as many best practices as permutations of priviledges -- any advice or suggestions for articles others have found helpful would be welcomed.

    Saturday, February 06, 2010 12:14 AM


All replies