On Fri, Aug 8, 2025 at 8:58 AM shveta malik <shveta.ma...@gmail.com> wrote: > > On Thu, Aug 7, 2025 at 3:08 PM Dilip Kumar <dilipbal...@gmail.com> wrote: > > > > So logically for PostgreSQL its an > > user table but yeah this is created and managed by the extension. > > > > Any idea if the user can alter/drop or perform any DML on it? I could > not find any details on this part.
In my experience, for such extension managed tables where we want them to behave like catalog, generally users are just granted with SELECT permission. So although it is not a catalog but for accessibility wise for non admin users it is like a catalog. IMHO, even if we choose to create a user table for conflict log history we can also control the permissions similarly. What's your opinion on this? -- Regards, Dilip Kumar Google
