From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
---|---|
To: | "Edson Richter" <edsonrichter(at)hotmail(dot)com>,"pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Permission for relationship but not for select is possible? |
Date: | 2013-01-04 20:51:29 |
Message-ID: | 20130104205129.4840@gmx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.html
http://www.postgresql.org/docs/9.2/static/sql-grant.html
http://www.postgresql.org/docs/9.2/static/sql-revoke.html
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-01-04 22:41:45 | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
Previous Message | Pavel Stehule | 2013-01-04 20:32:01 | Re: Curious unnest behavior |