new warning message

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: new warning message
Date: 2008-02-27 22:03:11
Message-ID: 1204149791.16886.45.camel@dogma.ljc.laika.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On IRC today someone brought up a problem in which users were still able
to connect to a database after a "REVOKE CONNECT ... FROM theuser". The
reason theuser is still able to connect is because PUBLIC still has
privileges to connect by default (AndrewSN was the one who answered
this).

Would it be reasonable to throw a warning if you revoke a privilege from
some role, and that role inherits the privilege from some other role (or
PUBLIC)?

Regards,
Jeff Davis

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-02-27 22:10:02 Re: Varlena Type Creation
Previous Message Pavel Stehule 2008-02-27 21:35:16 Re: proposal: plpgsql return execute ...

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-02-27 22:42:18 Re: new warning message
Previous Message Robert Lor 2008-02-27 21:27:22 Re: DTrace probe patch for OS X Leopard