select repId, orderNo, roleId, userId, readOnlyYn from ReportUserRole where repId = :report_id and userId is not null select repId, orderNo, roleId, userId, readOnlyYn from ReportUserRole where repId = :report_id and roleId is not null delete from ReportUserRole where repId = :report_id and userId =:user_id delete from ReportUserRole where repId = :report_id and roleId =:role_id