Search Postgresql Archives

Re: privileges oddity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Aug 7, 2020, at 12:17 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux