permission prob: granted, but still denied

Поиск
Список
Период
Сортировка
От s-psql@rhythm.cx
Тема permission prob: granted, but still denied
Дата
Msg-id 20021030015346.A17528@infinity.rhythm.cx
обсуждение исходный текст
Ответы Re: permission prob: granted, but still denied
Re: permission prob: granted, but still denied
Список pgsql-general
Hello, I'm having some sort of permission problem on my database, running
version 7.2.3.

The user in question is 'webauth', who does not own any of the objects in
question, nor is a superuser. He has been GRANTed ALL to a table 'websess' as
well as a table websess references, 'cscuser'. However, when that user
attempts to INSERT a valid row into table websess,

    ERROR: cscuser: Permission denied.

is returned. Does anyone know why that occurs? The owner of the database &
tables is able to insert rows just fine.

Here is a sample session:

% psql csclub webauth
csclub=> INSERT INTO websess(hash,userid,created)
         VALUES('ef7a3c41a798d535aba526d5c0dfe251',2,'2002-10-19');
ERROR:  cscuser: Permission denied.
csclub=> \z
           Access privileges for database "csclub"
          Table          |         Access privileges
-------------------------+------------------------------------
...
 websess                 | {=,webauth=arwdRxt}
 cscuser                 | {=,webauth=arwdRxt}
 cscuser_userid_seq     | {=,webauth=arwdRxt}
...


Thanks for any help.

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

Предыдущее
От: "Andrew Bartley"
Дата:
Сообщение: duplicate key in unique index pg_statistic_relid_att_index
Следующее
От: Tommi Maekitalo
Дата:
Сообщение: Re: gborg redirect problem