Re: GRANT - Mailing list pgsql-general

From Tom Lane
Subject Re: GRANT
Date
Msg-id 17750.989506548@sss.pgh.pa.us
Whole thread Raw
In response to GRANT  (Joakim Bomelin <jbm@gronaverket.se>)
List pgsql-general
Joakim Bomelin <jbm@gronaverket.se> writes:
> In MySQL I am able to set privileges on databases so user Ben can't
> access user Stephen's database, but I can't work that out in pgsql. Is
> it just me, or is GRANT only working for tables?

If you don't want Ben to get into Stephen's database at all, set up
connection permissions (pg_hba.conf) to prevent it.  GRANT only operates
within a database, it does not control connection permissions.

            regards, tom lane

pgsql-general by date:

Previous
From: John Coers
Date:
Subject: Re: COPY locking
Next
From: Tom Lane
Date:
Subject: Re: Re[2]: Vacuudb problem