RDS: permission denied for relation spatial_ref_sys when copying I am copying tables using ogr2ogr from Oracle to PostGIS. When I run try to load these I get,

ERROR 1: ERROR: permission denied for relation spatial_ref_sys when copying &lt;table&gt;@AWS
This error is a result of you not having access on that view. What you need to run to fix the permissions is

ALTER TABLE public.spatial_ref_sys OWNER TO rds_superuser;
GRANT SELECT, INSERT ON TABLE public.spatial_ref_sys TO public;


Found here on the AWS forums