Postgres Pro
Downloads
Home   >   mailing lists

Re: [postgresql 9.2.3] schema and privileges - Mailing list pgsql-novice

From Prashanth Goriparthi
Subject Re: [postgresql 9.2.3] schema and privileges
Date
Msg-id CA+Mf8bXZuqAbNoSnHPZkAjyOmxHAM+rfjr_HMn8Q3sOfPDa-SQ@mail.gmail.com
Whole thread Raw
In response to Re: [postgresql 9.2.3] schema and privileges  (Christian Hammers <ch@lathspell.de>)
List pgsql-novice
Tree view
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@lathspell.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: Christian Hammers
Date:
Subject: Re: [postgresql 9.2.3] schema and privileges
Next
From: Marcel Ruff
Date:
Subject: org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420