Re: [GENERAL] Extensions and privileges in public schema

2016-12-06 Thread Lee Hachadoorian
On Sun, Dec 4, 2016 at 4:24 PM, Paul Ramsey wrote: > When you create the student user, remove their create privs in public. > Then create a scratch schema and grant them privs there. > Finally, alter the student user so that the scratch schema appears FIRST > in their

Re: [GENERAL] Extensions and privileges in public schema

2016-12-05 Thread Charles Clavadetscher
gsql-general@postgresql.org> > Subject: Re: [GENERAL] Extensions and privileges in public schema > > When you create the student user, remove their create privs in public. > Then create a scratch schema and grant them privs there. > Finally, alter the student user so that the scratch

Re: [GENERAL] Extensions and privileges in public schema

2016-12-04 Thread Paul Ramsey
When you create the student user, remove their create privs in public. Then create a scratch schema and grant them privs there. Finally, alter the student user so that the scratch schema appears FIRST in their search path. This will cause unqualified CREATE statements to create in the scratch

[GENERAL] Extensions and privileges in public schema

2016-12-04 Thread Lee Hachadoorian
This question is specifically motivated by my use of the PostGIS extension, but since other extensions create functions and other supporting objects in public schema, I believe it is more general. I'm teaching a university-level class using PostGIS. I have created a scratch schema for students to