Re: Prevent users from creating tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Prevent users from creating tables
Date
Msg-id 20609.1086789987@sss.pgh.pa.us
Whole thread Raw
In response to Re: Prevent users from creating tables  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List pgsql-general
"Campano, Troy" <Troy.Campano@LibertyMutual.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiple databases on seperate drives/file systems?
Next
From: Tom Lane
Date:
Subject: Re: Multiple databases on seperate drives/file systems?