User:Dts1981/sandbox

SQL Server DBA Cheatsheet

SELECT HAS_PERMS_BY_NAME(QUOTENAME(SCHEMA_NAME(schema_id)) + '.' + QUOTENAME(name),'OBJECT', 'SELECT') AS Select_Priv, name, object_id, type,schema_id FROM sys.tables

T SQL : HAS_PERMS_BY_NAME

T SQL : sys.fn_my_permissions