Re: [GENERAL] rights for schema

2013-01-01 Thread Adrian Klaver
On 12/31/2012 02:40 PM, Philipp Kraus wrote: So the issue was that the user calling the function did not have access to the schema usermanagement. It is also possible the user did not have EXECUTE privileges on the function either. From your subsequent post I see you discovered SECURITY DEFI

Re: [GENERAL] rights for schema

2012-12-31 Thread Philipp Kraus
Am 31.12.2012 um 22:18 schrieb Adrian Klaver: > On 12/31/2012 09:02 AM, Philipp Kraus wrote: >> >> Am 31.12.2012 um 15:54 schrieb Adrian Klaver: >> >>> On 12/31/2012 05:41 AM, Philipp Kraus wrote: Am 31.12.2012 um 02:11 schrieb Adrian Klaver: >>> > > Actually as of 9.

Re: [GENERAL] rights for schema

2012-12-31 Thread Adrian Klaver
On 12/31/2012 09:02 AM, Philipp Kraus wrote: Am 31.12.2012 um 15:54 schrieb Adrian Klaver: On 12/31/2012 05:41 AM, Philipp Kraus wrote: Am 31.12.2012 um 02:11 schrieb Adrian Klaver: Actually as of 9.0 that is not strictly true: http://www.postgresql.org/docs/9.2/interactive/sql-alterdef

Re: [GENERAL] rights for schema

2012-12-31 Thread Philipp Kraus
Am 31.12.2012 um 18:02 schrieb Philipp Kraus: > > Am 31.12.2012 um 15:54 schrieb Adrian Klaver: > >> On 12/31/2012 05:41 AM, Philipp Kraus wrote: >>> >>> Am 31.12.2012 um 02:11 schrieb Adrian Klaver: >>> >> Actually as of 9.0 that is not strictly true: http://www.postgresql.o

Re: [GENERAL] rights for schema

2012-12-31 Thread Philipp Kraus
Am 31.12.2012 um 15:54 schrieb Adrian Klaver: > On 12/31/2012 05:41 AM, Philipp Kraus wrote: >> >> Am 31.12.2012 um 02:11 schrieb Adrian Klaver: >> > >>> >>> Actually as of 9.0 that is not strictly true: >>> http://www.postgresql.org/docs/9.2/interactive/sql-alterdefaultprivileges.html >> >>

Re: [GENERAL] rights for schema

2012-12-31 Thread Adrian Klaver
On 12/31/2012 05:41 AM, Philipp Kraus wrote: Am 31.12.2012 um 02:11 schrieb Adrian Klaver: Actually as of 9.0 that is not strictly true: http://www.postgresql.org/docs/9.2/interactive/sql-alterdefaultprivileges.html I have create a view for access a table and rules for modifiy the based t

Re: [GENERAL] rights for schema

2012-12-31 Thread Philipp Kraus
Am 31.12.2012 um 02:11 schrieb Adrian Klaver: > On 12/30/2012 04:06 PM, Christian Hammers wrote: >> Am Sun, 30 Dec 2012 15:54:32 +0100 >> schrieb Philipp Kraus : >> >>> Hello, >>> >>> can I set all rights to a schema and its content? I have different >>> schema and in the public schema all user

Re: [GENERAL] rights for schema

2012-12-31 Thread Philipp Kraus
Am 31.12.2012 um 02:11 schrieb Adrian Klaver: > On 12/30/2012 04:06 PM, Christian Hammers wrote: >> Am Sun, 30 Dec 2012 15:54:32 +0100 >> schrieb Philipp Kraus : >> >>> Hello, >>> >>> can I set all rights to a schema and its content? I have different >>> schema and in the public schema all user

Re: [GENERAL] rights for schema

2012-12-30 Thread Adrian Klaver
On 12/30/2012 04:06 PM, Christian Hammers wrote: Am Sun, 30 Dec 2012 15:54:32 +0100 schrieb Philipp Kraus : Hello, can I set all rights to a schema and its content? I have different schema and in the public schema all users should be do everything (select, update, delete, call functions, etc).

Re: [GENERAL] rights for schema

2012-12-30 Thread Christian Hammers
Am Sun, 30 Dec 2012 15:54:32 +0100 schrieb Philipp Kraus : > Hello, > > can I set all rights to a schema and its content? I have different > schema and in the public schema all users should be do everything > (select, update, delete, call functions, etc). Also if I add a new > user, the user shou

[GENERAL] rights for schema

2012-12-30 Thread Philipp Kraus
Hello, can I set all rights to a schema and its content? I have different schema and in the public schema all users should be do everything (select, update, delete, call functions, etc). Also if I add a new user, the user should be get also the rights. My other schemas are only access by the da