I added that to find Database permissions

--DATABASE permissions

SELECT replace(state_desc,'_with_grant_option','') + ' '+ permission_name + 'TO [' + USER_NAME(grantee_principal_id)+']' +

case

when state_desc like '%with_grant_option' then ' with grant option'

else

' '

end

as '--...

Hello

Interesting script but it seems some grant are not included.

I have a database with a role "dev" which I granted

GRANT CREATE PROCEDURE,CREATE FUNCTION,CREATE VIEW TO...

Oh yes ! you're right, thanks !

Hello

You script is using compatibility views. I prefer using dedicated views even if I need to have several version for different SQL Server version.

Here is my SQL script for SQL...