Re: privileges oddity

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: privileges oddity
Date: 2020-08-07 17:14:29
Message-ID: 75f2f28c-9121-c3d0-0c9a-f9b16ef337fb@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/7/20 9:23 AM, Scott Ribe wrote:
> Further update:
>
> create a new user, grant all on schema & the table, works
>
> reboot of server did not change anything, so the problem is in persistent state
>

What happens if you do?:

select has_schema_privilege('akanzler', 'zoewang', 'usage');

In psql what does

\ddp

show?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2020-08-07 17:31:52 Re: privileges oddity
Previous Message Scott Ribe 2020-08-07 16:23:04 Re: privileges oddity