John Hatfield <jhatfield(at)g-s(dot)com(dot)au> writes:
> When logged in as postgres (using psql)the following query returns an error
> gsmain_test=# select * from pgadmin_users;
> ERROR: pg_shadow: Permission denied.
pgadmin_users is a view, no? Which user was it created by? Views
execute with the permissions of the creating user, for reasons that
should be apparent after some thought.
regards, tom lane