RE: select * from pgadmin_users; causes error

Поиск
Список
Период
Сортировка
От John Hatfield
Тема RE: select * from pgadmin_users; causes error
Дата
Msg-id 01C09DAD.8E258320.jhatfield@g-s.com.au
обсуждение исходный текст
Ответ на select * from pgadmin_users; causes error  (John Hatfield <jhatfield@g-s.com.au>)
Ответы Re: select * from pgadmin_users; causes error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Yes your right.  Thanks.

It looks as though the views are created the first time you login to
pgAdmin.  So when I logged first as an ordinary user not as the postgres
(database superuser), the views were created with this user as the owner.

A trap for beginners!!

regards

John

-----Original Message-----
From:    Tom Lane
Sent:    Friday, 23 February 2001 3:01 PM
To:    jhatfield@g-s.com.au
Cc:    'PostgreSQL Admin News'
Subject:    Re: [ADMIN] select * from pgadmin_users; causes error

John Hatfield <jhatfield@g-s.com.au> writes:
> When logged in as postgres (using psql)the following query returns an
error
> gsmain_test=# select * from pgadmin_users;
> ERROR:  pg_shadow: Permission denied.

pgadmin_users is a view, no?  Which user was it created by?  Views
execute with the permissions of the creating user, for reasons that
should be apparent after some thought.

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: select * from pgadmin_users; causes error
Следующее
От: Jaume Teixi
Дата:
Сообщение: ...