Thursday, March 29, 2012

Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:
>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.

No comments:

Post a Comment