Re: privileges oddity

On 8/7/20 11:25 AM, Scott Ribe wrote:
>> On Aug 7, 2020, at 12:17 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>>
>> Well if this for the same line as before it represents table privileges. The problem is with schema access.
Continuinggrasping 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.klaver@aklaver.com