Post reply

List all permission in all databases

  • September 25, 2014 at 11:30 am

    #1748264

    Hi Folks!

    Nice script! The only problem I see it's when the user (o role) have permission on a schema instead of a table. In that case the script will show that the user have permission on a system table (like sysrowsets) because the mayor_id value is 5, and that correspond to the sys.schemas view (schema_id) and not the sys.sysobjects (object_id).

    Regards.

    JP.

  • May 17, 2016 at 6:41 am

    #1879484

    Thanks for the script.

  • December 21, 2017 at 10:12 am

    #1973123

    Thanks for this great script!!
    FYI, I have a couple of offline databases on a non-production server and got an error that stopped the script when I ran it.
    I was able to work around it by modifying the sys.databases query to this:
    select name from sys.databases where state_desc = 'ONLINE' order by name

    Thanks again!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply