A list of permissions associated with each security role in Document Format? RRS feed

  • Question

  • I need to tell someone the exact permissions of each role.  If I can avoid making screenshots and this information is already available, then I would prefer to locate the documentation instead of making a massive collection of screenshots.

    Is this recorded anywhere?
    Tuesday, August 18, 2015 9:16 PM

All replies

  • You could run a verbose trace or a profiler trace of you opening a specific role to capture the SQL query and then build a report to do it.  That query should be using the filtered views and so be in a completely supported format from that end but there isn't anything I've heard of that does a printable version of all of the privs. 



    Wednesday, August 19, 2015 3:22 PM