FW: select * from pgadmin_users; causes error

Seem to have fixed the problem by dropping and re-creating the database.

Thanks.

John

-----Original Message-----
From: John Hatfield
Sent: Friday, 23 February 2001 11:35 AM
To: 'PostgreSQL Admin News'
Subject: [ADMIN] select * from pgadmin_users; causes error

Hi

I'm new to postgresql.

When logged in as postgres (using psql)the following query returns an error
gsmain_test=# select * from pgadmin_users;
ERROR: pg_shadow: Permission denied.

I can select from pg_user and pg_shadow.

The reason I am trying to run the above query is I had the same error when trying to view users/groups from pgAdmin.

The database was created using user postgres

My system
Linux Box
Postgresql 7.0.3-2 installed from rpms
Redhat 7.0

Win98 Box
pgAdmin v7.0.5
odbc driver 6.50.00.00
mdac 2.6

Thanks in advance

John