• I have actually figured it out using the following script seems to work:

    SELECT State_desc + ' ' + [permission_name] + ' ON ' + object_name(major_id) + ' TO USER' FROM sys.database_permissions

    Where grantee_principal_id = 7

    order by object_name(major_id)