Maybe this is not quite what you are looking for (though it might be) but it is a start.

sp_helprotect

http://msdn2.microsoft.com/en-us/library/ms190310(SQL.90).aspx