You can create an AllUserRights macro to list all privileges a user has on a specific database. The macro gets information from the DBC.AllRightsV and DBC.AllRolesRightsV views, and spells out the two-character privilege code found in the AccessRightDesc field of the views.