Re: [ADMIN] select * from pgadmin_users; causes error

[Tom Lane]

John Hatfield <[EMAIL PROTECTED]> 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