Re: Including PL/PgSQL by default - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Including PL/PgSQL by default
Date
Msg-id 47BDC408.7060206@dunslane.net
Whole thread Raw
In response to Re: Including PL/PgSQL by default  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Including PL/PgSQL by default  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Including PL/PgSQL by default  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-hackers

Joshua D. Drake wrote:
>
> Notice that user foo is not a super user. Now I log into
> PostgreSQL and connect to the postgres database (the super users
> database) as the non privileged user "foo". The user "foo" in theory
> has *zero* rights here accept that he can connect.
>
>
>   

That's not true. The public schema has public UC privs, and always has had.

There is nothing surprising (expect possibly to you) here.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: insufficient data left in message
Next
From: Tom Lane
Date:
Subject: Re: Including PL/PgSQL by default