User Role Permissions

From: Bish (Bish_at_discussions.microsoft.com)
Date: 11/25/04


Date: Thu, 25 Nov 2004 04:33:06 -0800

sIs there a system stored proc that provide access to changing the
permissions on a user role.

I am using the sp_addrole to create a role and sp_addrolemember to add a
member but wish also to script certain permissions in the new role.

....thanks