USE Your_Database; GO EXECUTE AS USER = N'the_user_name'; GO SELECT s.name, o.name, p.[permission_name] FROM sys.objects AS o INNER JOIN sys.schemas AS s ON o.[schema_id] = s.[schema_id] CROSS APPLY sys.fn_my_permissions(QUOTENAME(s.name) + N'.' + QUOTENAME(o.name), N'OBJECT') AS p WHERE o.[type] IN (N'U', N'V') -- tables and views AND p.subentity_name = N''; -- ignore column permissions GO REVERT;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter