Re: privileges oddity - Mailing list pgsql-general

From Adrian Klaver
Subject Re: privileges oddity
Date
Msg-id 75f2f28c-9121-c3d0-0c9a-f9b16ef337fb@aklaver.com
Whole thread Raw
In response to Re: privileges oddity  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: privileges oddity  (Scott Ribe <scott_ribe@elevated-dev.com>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: privileges oddity
Next
From: Scott Ribe
Date:
Subject: Re: privileges oddity