Edson Richter wrote:
> 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?
Yes.
It's pretty straightforward. You don't need permissions on a related
table for the constraints to be enforced.
> Can you help me to find relevant page in manuals for 9.1 or 9.2?
http://www.postgresql.org/docs/9.2/static/sql-createtable.htmlhttp://www.postgresql.org/docs/9.2/static/sql-grant.htmlhttp://www.postgresql.org/docs/9.2/static/sql-revoke.html
-Kevin