$ psql oar2
  GRANT ALL PRIVILEGES ON schema,accounting,admission_rules,assigned_resources,
  challenges,event_log_hostnames,event_logs,files,frag_jobs,gantt_jobs_predictions,
  gantt_jobs_predictions_visu,gantt_jobs_resources,gantt_jobs_resources_visu,
  job_dependencies,job_resource_descriptions,job_resource_groups,
  job_state_logs,job_types,jobs,moldable_job_descriptions,queues,
  resource_logs,resources,admission_rules_id_seq,event_logs_event_id_seq,
  files_file_id_seq,job_resource_groups_res_group_id_seq,
  job_state_logs_job_state_log_id_seq,job_types_job_type_id_seq,
  moldable_job_descriptions_moldable_id_seq,resource_logs_resource_log_id_seq,
  resources_resource_id_seq,jobs_job_id_seq TO oar;

 GRANT SELECT ON schema,accounting,admission_rules,assigned_resources,event_log_hostnames,
  event_logs,files,frag_jobs,gantt_jobs_predictions,gantt_jobs_predictions_visu,
  gantt_jobs_resources,gantt_jobs_resources_visu,job_dependencies,
  job_resource_descriptions,job_resource_groups,job_state_logs,job_types,
  jobs,moldable_job_descriptions,queues,resource_logs,resources,admission_rules_id_seq,
  event_logs_event_id_seq,files_file_id_seq,job_resource_groups_res_group_id_seq,
  job_state_logs_job_state_log_id_seq,job_types_job_type_id_seq,
  moldable_job_descriptions_moldable_id_seq,resource_logs_resource_log_id_seq,
  resources_resource_id_seq,jobs_job_id_seq TO oar_ro;