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