Re: Permission Problems - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Permission Problems
Date
Msg-id 4ECD6C55.7070001@commandprompt.com
Whole thread Raw
In response to Permission Problems  (Bill Thoen <bthoen@gisnet.com>)
List pgsql-general
On 11/23/2011 01:54 PM, Bill Thoen wrote:

> Am I digging too deep here, or what am I missing? Is there a better way
> to tranfer info between my database and the web than by using a generic
> account? It sure seems like I'm granting too much access to too little a
> player. Any advice would be welcome.

If you are just letting people view, I would create views of what is
allowed to be viewed and grant read permission to just the views to the
unprivalged account.

JD


>
> TIA,
> - Bill Thoen
>


--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579

pgsql-general by date:

Previous
From: Bill Thoen
Date:
Subject: Permission Problems
Next
From: Tom Lane
Date:
Subject: Re: plpgsql Difference in behaviour between versions?