Richard Colman wrote: > 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.
A new user normally can't do anything. Just grant the privileges on the view to him. You may also want to revoke all permissions on databases and schemas, some of which are set to allow everything by default. The GRANT manual page contains more information and pointers. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match