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




Reply via email to