Re: Prevent users from creating tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
Cc: btober(at)computer(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Prevent users from creating tables
Date: 2004-06-09 14:06:27
Message-ID: 20609.1086789987@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> writes:
> So by default, all users have privs to create tables in schema 'public'?
> Why would postgresql developers decide to do that instead of denying all
> access unless it is granted? For ease of use? Just curious.

That and backwards compatibility. There are some other exceptions to
the "no access by default" rule, too --- see the GRANT reference page.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-09 14:20:15 Re: Multiple databases on seperate drives/file systems?
Previous Message Scot L. Harris 2004-06-09 13:45:10 Re: Multiple databases on seperate drives/file systems?