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

From Roberts, Jon
Subject Re: Including PL/PgSQL by default
Date
Msg-id 1A6E6D554222284AB25ABE3229A9276271560A@nrtexcus702.int.asurion.com
Whole thread Raw
In response to Re: Including PL/PgSQL by default  (Andrew Dunstan <andrew@dunslane.net>)
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.
>

Is it safe to remove UC privs on the public schema?  Having rights to
"connect" should mean connect, not connect and create.


Jon


Jon


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: VARATT_EXTERNAL_GET_POINTER is not quite there yet
Next
From: Andrew Sullivan
Date:
Subject: Re: Including PL/PgSQL by default