From: | "Joris Dobbelsteen" <Joris(at)familiedobbelsteen(dot)nl> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | CONNECT privilege |
Date: | 2006-11-26 18:33:47 |
Message-ID: | 73427AD314CC364C8DF0FFF9C4D693FF542D@nehemiah.joris2k.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've set up a little test to find out how much permissions users have in
PostGreSQL.
It seems that the CONNECT privilege cannot be assigned or is not
recognized by postgresql 8.1.
When using pgAdmin-III it does not display the granted CONNECT
priviledge.
Also when doing GRANT CONNECT FOR DATABASE <db> TO <user/group> it
succeeds, but I fail to observe its effects: i.e. users are not allowed
to a database.
The public rule has been removed of course from the database.
I did find GRANT CONNECT in the documentation, but no notes regarding
its operation.
Also I have read at least the pgAdmin documentation advices to use the
connect privilege rather than pg_hba configuration file, which seems
logical and easier to manage.
Any way I seem to be doing something wrong or missed something?
Thanks,
- Joris
From | Date | Subject | |
---|---|---|---|
Next Message | Mikko Partio | 2006-11-26 18:40:43 | Re: CONNECT privilege |
Previous Message | Richard Troy | 2006-11-26 18:22:55 | Re: Development of cross-platform GUI for Open Source DBs |