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.
sql
Thursday, March 29, 2012
Exporting Role Permissions
Labels:
database,
export,
exporting,
format,
friendly,
microsoft,
mysql,
oracle,
permissions,
role,
server,
sql,
theauditors,
user,
wouldmimic
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment