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
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 |