create view [dbo].[v_my_permissions]
as
 

WITH Q0 as
(
SELECT T.TABLE_TYPE AS OBJECT_TYPE, T.TABLE_SCHEMA AS [SCHEMA_NAME], T.TABLE_NAME AS [OBJECT_NAME], P.PERMISSION_NAME 
    FROM INFORMATION_SCHEMA.TABLES T
    CROSS APPLY fn_my_permissions(T.TABLE_SCHEMA + '.' + T.TABLE_NAME, 'OBJECT') P
    WHERE P.subentity_name = ''
UNION
SELECT R.ROUTINE_TYPE AS OBJECT_TYPE, R.ROUTINE_SCHEMA AS [SCHEMA_NAME], R.ROUTINE_NAME AS [OBJECT_NAME], P.PERMISSION_NAME
    FROM INFORMATION_SCHEMA.ROUTINES R
    CROSS APPLY fn_my_permissions(R.ROUTINE_SCHEMA + '.' + R.ROUTINE_NAME, 'OBJECT') P
	where R.ROUTINE_NAME not in('fn_diagramobjects','sp_alterdiagram','sp_creatediagram','sp_dropdiagram','sp_helpdiagramdefinition','sp_helpdiagrams','sp_renamediagram')
)
,Q2 as
(
SELECT DISTINCT
 OBJECT_TYPE
,SCHEMA_NAME
,OBJECT_NAME
,substring((select '; ' + PERMISSION_NAME from Q0 b WHERE a.OBJECT_NAME=b.OBJECT_NAME and a.OBJECT_TYPE=b.OBJECT_TYPE and a.SCHEMA_NAME=b.SCHEMA_NAME order by b.permission_name for XML path('')),2,1000) PERMISSIONS
from Q0 a
)
select top 100000 * from Q2
where PERMISSIONS <> ' VIEW DEFINITION'
order by SCHEMA_NAME, OBJECT_NAME
GO

--идея: http://dbadailystuff.com/2012/08/20/get-sql-server-user-permissions