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






---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to