Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE TABLE in PUBLIC schema - Mailing list pgsql-admin

From Tom Lane
Subject Re: CREATE TABLE in PUBLIC schema
Date
Msg-id 21347.1037197874@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TABLE in PUBLIC schema  (Heni Lolov <hal_bg@yahoo.com>)
Responses Re: CREATE TABLE in PUBLIC schema  (Heni Lolov <hal_bg@yahoo.com>)
List pgsql-admin
Tree view 
Heni Lolov <hal_bg@yahoo.com> writes:
> SO WILL THERE EVER BE POSSIBLE TO DISALLOW
> OBJECT CREATION TO USERS AND TO GIVE THEM
> ONLY READ ACCESS TO SOME OBJECTS IN A DB?

If you'd quit shouting and RTFM, you'd find out that it's possible in
7.3.  (Hint: drop the public schema or revoke privileges on it.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: gmake check runs just 13 tests instead of 77
Next
From: Heni Lolov
Date:
Subject: Re: CREATE TABLE in PUBLIC schema