CREATE proc dbo.sp_AllRights
@UserName sysname
AS

CREATE TABLE #UserInRoles (UserName sysname, GroupName sysname, LoginName sysname NULL,
DefDBName sysname NULL, UserID smallint, SID smallint)
INSERT #UserInRoles exec sp_helpuser @UserName

ALTER TABLE #UserInRoles drop column UserName, LoginName, DefDBName, UserID, SID
INSERT #UserInRoles (GroupName) values ('public')

CREATE TABLE #RightsOnObjects (Owner sysname, Object sysname, Grantee sysname, Grantor sysname,
ProtectType char(10), [Action] varchar(20), [Column] sysname NULL)
INSERT #RightsOnObjects exec sp_helprotect

SELECT * FROM #RightsOnObjects
WHERE Grantee IN (SELECT GroupName FROM #UserInRoles) OR Grantee = @UserName
ORDER BY Object, Action, [Column], ProtectType
GO