Re: [GENERAL] Permission for relationship but not for select is possible?

2013-01-04 Thread Kevin Grittner
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

[GENERAL] Permission for relationship but not for select is possible?

2012-12-31 Thread Edson Richter
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