Обсуждение: 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