grants gives - Search results

Mailing lists  >>  pgsql-admin  >>  Thread

2024-05-05 07:29:07 | Re: Foreign tables - oracle_fdw (Edwin UY)

grant all on [foreign_table] to [schema1_owner], then I login as [schema1_owner] and tried doing select * from the [foreign_table] or select * from [user1].[foreign_table] and it gives

Mailing lists  >>  pgsql-admin  >>  Thread

2024-05-05 03:07:38 | Foreign tables - oracle_fdw (Edwin UY)

gives ERROR: permission denied for schema public I have to do GRANT ALL ON SCHEMA