Re: select * from pgadmin_users; causes error

John Hatfield <jhatfield@g-s.com.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