Re: privileges oddity

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: privileges oddity
Date: 2020-08-07 18:25:43
Message-ID: 5AA78DA8-746A-4407-AC00-B1463451CAD0@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-08-07 18:27:37 Re: privileges oddity
Previous Message Adrian Klaver 2020-08-07 18:17:30 Re: privileges oddity