select * from pgadmin_users; causes error

From: John Hatfield <jhatfield(at)g-s(dot)com(dot)au>
To: "'PostgreSQL Admin News'" <pgsql-admin(at)postgresql(dot)org>
Subject: select * from pgadmin_users; causes error
Date: 2001-02-23 01:35:13
Message-ID: 01C09D8C.B0795DA0.jhatfield@g-s.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-02-23 03:50:48 Re: problem while compiling user c functions in 7.1beta4
Previous Message Adam Rose 2001-02-23 01:00:59 Column character length