This message was sent from Geocrawler.com by "Tim Perdue" <[EMAIL PROTECTED]>
Be sure to reply to that address.
I've never seen an answer posted to these
questions on the mailing list and there's no
mention in the docs AFAICT.
There's got to be a way to create multiple
databases and have each one protected by a
different username/password. Right now, any
authorized user can connect to any database. Grant
only works on tables, which is not useful in this
case (grant against a DB would be useful).
Could someone reply to me and copy the list for
posterity??
Tim
[EMAIL PROTECTED]
-------------------------------------
Okay, here`s my question for the week...
I have a server that I want to run
with multiple client databases, each
one password protected...but how do I
get it so that userA can`t connect
to userB`s database, or vice versa?
I know I can grant/revoke on the
tables, but how do I grant/revoke on the
database`s themselves?
For instance, i don`t want someone to
be able to connect to their
database, and then do a connect <userB
database> ...
Is this currently possible? Or do we
not have that level of granularity
yet?
Marc G. Fournier
ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED]
secondary: scrappy@{freebsd|postgresql}.org
Geocrawler.com - The Knowledge Archive
************
