2

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 <table>@AWS
1
  • did this answer help? Commented Jul 27, 2019 at 23:59

1 Answer 1

3

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.