Permission for relationship but not for select is possible?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Permission for relationship but not for select is possible?
Date: 2012-12-31 18:14:58
Message-ID: BLU0-SMTP251F376DEB008660F231F29CF3C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to have two schemas:

MyDB.sales
MyDB.security

Users that have rights in sales schema should be able to
select/insert/update/delete. The same users must have rights to check
foreign keys against users table (but they are now allowed to execute
select on this table).
Is that possible? Can you help me to find relevant page in manuals for
9.1 or 9.2?

I wish to you all a Happy New Year!

Thanks,

Edson

Browse pgsql-general by date

  From Date Subject
Next Message Philipp Kraus 2012-12-31 19:15:36 trigger on adding / deleting / modify user on pg_authid
Previous Message Philipp Kraus 2012-12-31 17:36:40 Re: rights for schema