MS SQL Server - Exporting Role Permissions

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Exporting Role Permissions

skinnker

2006-10-24, 6:31 pm

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.

Sue Hoegemeier

2006-10-24, 6:31 pm

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.

Sponsored Links