select * from pgadmin_users; causes error

Поиск
Список
Период
Сортировка
От John Hatfield
Тема select * from pgadmin_users; causes error
Дата
Msg-id 01C09D8C.B0795DA0.jhatfield@g-s.com.au
обсуждение исходный текст
Ответы Re: select * from pgadmin_users; causes error
Список 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





В списке pgsql-admin по дате отправления:

Предыдущее
От: Adam Rose
Дата:
Сообщение: Column character length
Следующее
От: M Carling
Дата:
Сообщение: Re: v7.1b4 bad performance