Permission for relationship but not for select is possible? - Mailing list pgsql-general

From Edson Richter
Subject Permission for relationship but not for select is possible?
Date
Msg-id BLU0-SMTP251F376DEB008660F231F29CF3C0@phx.gbl
Whole thread Raw
List 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


pgsql-general by date:

Previous
From: Philipp Kraus
Date:
Subject: Re: rights for schema
Next
From: Philipp Kraus
Date:
Subject: trigger on adding / deleting / modify user on pg_authid