From: | John Hatfield <jhatfield(at)g-s(dot)com(dot)au> |
---|---|
To: | "'PostgreSQL Admin News'" <pgsql-admin(at)postgresql(dot)org> |
Subject: | FW: select * from pgadmin_users; causes error |
Date: | 2001-02-23 03:56:12 |
Message-ID: | 01C09DA0.62AB5E20.jhatfield@g-s.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-02-23 05:00:58 | Re: select * from pgadmin_users; causes error |
Previous Message | Tom Lane | 2001-02-23 03:50:48 | Re: problem while compiling user c functions in 7.1beta4 |