Re: Schema/user/role

2023-03-20 Thread Ron Johnson
https://dba.stackexchange.com/questions/37012/difference-between-database-vs-user-vs-schema On Mon, Mar 20, 2023 at 2:57 PM Bryn Llewellyn wrote: > > david.g.johns...@gmail.com wrote: > > > >> adapt...@comcast.net wrote: > >> > >> Is there any good reference to explain the best usage of each

Re: Schema/user/role

2023-03-20 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > >> adapt...@comcast.net wrote: >> >> Is there any good reference to explain the best usage of each of these >> structures. I am coming from Oracle. What is the best analog to Oracle's >> "user". > > A schema is a namespace mechanism for objects. It has

Re: Schema/user/role

2023-03-20 Thread David G. Johnston
On Mon, Mar 20, 2023 at 9:13 AM DAVID ROTH wrote: > Is there any good reference to explain the best usage of each of these > structures. > I am coming from Oracle. What is the best analog to Oracle's "user". > A schema is a namespace mechanism for objects. It has no relationship to roles

Schema/user/role

2023-03-20 Thread DAVID ROTH
Is there any good reference to explain the best usage of each of these structures. I am coming from Oracle. What is the best analog to Oracle's "user". Thanks Dave Roth > On 03/20/2023 10:15 AM Ron Johnson wrote: > > > Real-time CDC is the difficult part. ora2pg (using views) can do