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@g-s.com.au
Cc: 'PostgreSQL Admin News'
Subject: Re: [ADMIN] 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