Heni Lolov <[EMAIL PROTECTED]> writes:
> ive tried :
> revoke all ON schema public from hal;
> but does not work. Why?
You'd need to revoke the permissions from PUBLIC; they were never granted
specifically to hal, thus the above revoke is a no-op.
Don't forget to revoke CREATE at the database lev
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 T
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 privilege
Hi
I have just downloaded and installed PgSQL 7.3b5.
Unfortunately the same problem is still there. There
is no way to diallow creating tables in the database.
Every user is able to crete tables in every database.
So there is no much sence to disallow users to create
schemas when they can create
