Re: Permission Problems

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bill Thoen <bthoen(at)gisnet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission Problems
Date: 2011-11-23 21:57:41
Message-ID: 4ECD6C55.7070001@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-11-23 22:02:06 Re: plpgsql Difference in behaviour between versions?
Previous Message Bill Thoen 2011-11-23 21:54:42 Permission Problems