Re: privileges oddity

On 8/7/20 11:25 AM, Scott Ribe wrote:
>> On Aug 7, 2020, at 12:17 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>>
>> Well if this for the same line as before it represents table privileges. The problem is with schema access. Continuing grasping at straws:
>>
>> select * from pg_roles where rolname = 'aakanzler';
>
> rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil | rolbypassrls | rolconfig | oid
> ----------+----------+------------+---------------+-------------+-------------+----------------+--------------+-------------+---------------+--------------+-------------------------------+-------
> akanzler | f | t | f | f | t | f | -1 | ******** | | f | {role=confidential_read_only} | 16391
>

So what privileges does role 'confidential_read_only' have?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com