Re: [postgresql 9.2.3] schema and privileges

Like Christian Hammers already mentioned, you need to grant access to each
and every object in that schema to user1 for having access to it.

Here is an example of how those grants look like:

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE table_x TO user1;

GRANT SELECT, UPDATE ON TABLE table_x_table_x_id_seq TO user1;

Same this applies for all functions/views etc etc., I hope this is clear to
you.

Thanking you,
Prashanth Kumar Goriparthi

On Thu, Mar 14, 2013 at 2:08 PM, Christian Hammers <ch(at)lathspell(dot)de> wrote:

> Read the last sentence again ,-) You gave rights to only the Schema not
> everything below it.
>
> bye,
> -christian-
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>