SET NOCOUNT ON;

DECLARE @Database TABLE (DbName SYSNAME);
DECLARE @DbName AS SYSNAME;
DECLARE @sql AS VARCHAR(MAX);
DECLARE @ServerName AS SYSNAME;

SET @ServerName = (
		SELECT @@SERVERNAME
		);

IF OBJECT_ID(N'tempdb..#User') IS NOT NULL
BEGIN
	DROP TABLE #User
END;

CREATE TABLE #User (
	ServerName SYSNAME
	,DbName SYSNAME
	,UserName SYSNAME NULL
	,LoginType VARCHAR(255) NULL
	,Permission VARCHAR(255) NULL
	,StateOf VARCHAR(255) NULL
	,AccessLevel VARCHAR(255) NULL
	,ObjectName SYSNAME NULL
	);

SET @DbName = '';

INSERT INTO @Database (DbName)
SELECT NAME
FROM master.dbo.sysdatabases
WHERE NAME <> 'tempdb'
ORDER BY NAME ASC;

WHILE @DbName IS NOT NULL
BEGIN
	SET @DbName = (
			SELECT MIN(DbName)
			FROM @Database
			WHERE DbName > @DbName
			)
	/*
	PUT CODE HERE
	*/
	SET @sql = '
INSERT INTO #User (
	ServerName
	,DbName
	,UserName
	,LoginType
	,Permission
	,StateOf
	,AccessLevel
	,ObjectName
	)
SELECT ''' + @ServerName + ''' AS ServerName
	,''' + @DbName + ''' AS DbName
	,princ.name AS UserName
	,princ.type_desc AS LoginType
	,perm.permission_name AS Permission
	,perm.state_desc AS StateOf
	,perm.class_desc AS AccessLevel
	,object_name(perm.major_id) AS ObjectName
FROM ' + QUOTENAME(@DbName) + '.sys.database_principals princ
LEFT JOIN ' + QUOTENAME(@DbName) + '.sys.database_permissions perm ON perm.grantee_principal_id = princ.principal_id
'

	EXEC (@sql)
END;

SELECT *
FROM #User;

DROP TABLE #User;