RE: select * from pgadmin_users; causes error

Yes your right. Thanks.

It looks as though the views are created the first time you login to
pgAdmin. So when I logged first as an ordinary user not as the postgres
(database superuser), the views were created with this user as the owner.

A trap for beginners!!

regards

John

-----Original Message-----
From: Tom Lane
Sent: Friday, 23 February 2001 3:01 PM
To: jhatfield(at)g-s(dot)com(dot)au
Cc: 'PostgreSQL Admin News'
Subject: Re: [ADMIN] select * from pgadmin_users; causes error

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