oracle8.1.6 select calendar_id, calendar_name, ' ' as checked_p from calendars where acs_permission.permission_p(calendar_id, :user_id, 'calendar_read') = 't' and acs_permission.permission_p(calendar_id, :user_id, 'calendar_show') = 't' and private_p = 'f' union select calendar_id, calendar_name, ' ' as checked_p from cal_items, calendars where acs_permission.permission_p(cal_item_id, :user_id, 'cal_item_read') = 't' and calendar.private_p(on_which_calendar) = 'f' and calendars.private_p = 'f' and cal_items.on_which_calendar = calendars.calendar_id