Granting privileges to a schema to a role

2023-09-11 Thread Johnson, Bruce E - (bjohnson)
(Background I’m working on migrating an existing set of Oracle schemas with a bunch of inter-schema grants to a Postgres 15 system) I’ve created the database ‘webdata', successfully used ora2pg to migrate one schema ‘trav’ to Postgres. The schema on the oracle side is called trav the owner is w

Re: Granting privileges to a schema to a role

2023-09-11 Thread Erik Wienhold
On 11/09/2023 20:07 CEST Johnson, Bruce E - (bjohnson) wrote: > I’ve created the database ‘webdata', successfully used ora2pg to migrate one > schema ‘trav’ to Postgres. > > The schema on the oracle side is called trav the owner is webdata, and I > created the role trav and granted all table rig