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 <[EMAIL PROTECTED]> wrote: > Heni Lolov <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
