Re: GRANT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joakim Bomelin <jbm(at)gronaverket(dot)se>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT
Date: 2001-05-10 14:55:48
Message-ID: 17750.989506548@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joakim Bomelin <jbm(at)gronaverket(dot)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

In response to

  • GRANT at 2001-05-10 09:45:25 from Joakim Bomelin

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2001-05-10 15:05:33 Re: ER diagrams
Previous Message ryan 2001-05-10 14:53:21 Re: Query not using index