Re: [GENERAL] Privileges on public schema can't be revoked?

2016-09-06 Thread Greg Fodor
eges granted to user on an object and why, or another where you simply submit a statement to the DB and it gives you an audit trail of why that statement is permitted (EXPLAIN PRIVILEGES? :)) Thanks for the info! On Tue, Sep 6, 2016 at 11:07 AM, Tom Lane wrote: > Greg Fodor writes: >> Ap

[GENERAL] Privileges on public schema can't be revoked?

2016-09-06 Thread Greg Fodor
Apologies in advance about this since it is likely something obvious, but I am seeing some very basic behavior that does not make sense. I've tested this on a fresh build of 9.6rc1 and also 9.1.24 (just to see if it was a regression.) After creating a test database, and a test user that I revoke al