Re: privileges oddity
| От | Scott Ribe |
|---|---|
| Тема | Re: privileges oddity |
| Дата | |
| Msg-id | 5AA78DA8-746A-4407-AC00-B1463451CAD0@elevated-dev.com обсуждение |
| Ответ на | Re: privileges oddity (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: privileges oddity
|
| Список | pgsql-general |
> 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
В списке pgsql-general по дате отправления: