On 8/7/20 11:25 AM, Scott Ribe wrote:
On Aug 7, 2020, at 12:17 PM, Adrian Klaver <adrian.kla...@aklaver.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.kla...@aklaver.com


Reply via email to