From: | Heni Lolov <hal_bg(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: CREATE TABLE in PUBLIC schema |
Date: | 2002-11-13 15:58:42 |
Message-ID: | 20021113155842.41664.qmail@web21001.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Sorry :)
forgive me please!
ive tried :
revoke all ON schema public from hal;
but does not work. Why?
with drop it worked :)
Ive got :
ERROR: No namespace has been selected to create in
regards,
hal
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Heni Lolov <hal_bg(at)yahoo(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
From | Date | Subject | |
---|---|---|---|
Next Message | Mr OCP | 2002-11-13 16:39:19 | Re: gmake check runs just 13 tests instead of 77 |
Previous Message | Christian Frabel | 2002-11-13 15:33:24 | Databases directory |