• I believe this would get you the schema permissions you are looking for. I'll have to update my script to include that as well.

    select state_desc+ ' ' + permission_name + ' TO ' + class_desc + '::' + QUOTENAME(SCHEMA_NAME(grantee_principal_id)), perm.state

    from sys.database_permissions AS perm

    inner join sys.schemas s

    on perm.grantee_principal_id = s.schema_i

    WHERE class_desc = 'SCHEMA' --class = 3

    I did some minimal testing with that code and it seems to work as you desire.

    I'm sure there will be other facets missing, so please let me know if you see anything else missing that would be a benefit to the community.

    Thanks,

    Steve