--This script will generate all user permissions and the code to

recreate them as required.

SELECT C.name 'Schema',

B.name AS Object,

D.name username,

A.type permissions_type,

A.permission_name,

A.state permission_state,

A.state_desc,

state_desc

+ ' ' + permission_name

+ ' ON ['+ C.name

+ '].[' + B.name + '] to ['

+ D.name

+ ']' COLLATE LATIN1_General_CI_AS AS

Generated_Code

FROM sys.database_permissions AS A JOIN sys.objects AS B ON

A.major_id =

B.object_id

JOIN sys.schemas AS C ON B.schema_id =

C.schema_id

JOIN sys.database_principals AS D ON

A.grantee_principal_id = D.principal_id

ORDER BY 1, 2, 3, 5

MJ