ERROR: syntax error at or near "ALL" postgres GRANT psql 8.4.15

1.7k views Asked by At

I have a postgresql version 8.4.15 database and when I want to give a user permissions on tables, I get a syntax error that in postgres version 11.5 it doesn't.

ERROR:  syntax error at or near "ALL"
LINE 1: GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO consulta;

ERROR:  syntax error at or near "ALL"
LINE 1: GRANT SELECT ON ALL TABLES IN SCHEMA public TO consulta;
0

There are 0 answers