Re: Limiting user access to a view only - Mailing list pgsql-admin

Richard Colman wrote:
> I am a novice in this area.>> How would I set up a new user on PostgreSQL so that the new user is
limited> to reading a particular view, and can do nothing else.

Hi,
first of all create the user as no a super user, after use the
GRANT  command ( http://www.postgresql.org/docs/7.4/interactive/sql-grant.html )


in your case:

GRANT SELECT ON <view_name> TO <user_name>



Regards
Gaetano Mendola