On Thu, Jul 31, 2025 at 4:13 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 7/31/25 04:37, Dominique Devienne wrote: > So the below from the original post was not correct: > > "My setup ensures that the role I SET LOCAL ROLE to, has (indirectly) > been granted DMLs on that table."
Not so. DML is Data Modification Language. I did grant INSERT, UPDATE, DELETE. As opposed to DQL, Data Query Language. And yes, I failed to grant SELECT. Normally SELECT comes from yet another role. But not in this specific case.
