Need SELECT rights to UPDATE/DELETE WHERE?

Поиск
Список
Период
Сортировка
От cpp@world-online.no
Тема Need SELECT rights to UPDATE/DELETE WHERE?
Дата
Msg-id 41C17A7100006F65@cpfe4.be.tisc.dk
обсуждение исходный текст
Ответы Re: Need SELECT rights to UPDATE/DELETE WHERE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
PostgreSQL 8.0.0 on WinXP Pro, libpq

In my hands it looks like a user with INSERT/DELETE/UPDATE rights on table1
cannot do "update table1 set field1=xx where field2=yy" without also being
granted select rights. However, the user can do "update table1 set field1=xx".
Is this right? Any explanations why it should be like this and any suggestions
on how to get around it without granting select is greatly appreciated.

KP




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

Предыдущее
От: Mischa
Дата:
Сообщение: Re: same question little different test MSSQL vrs Postgres
Следующее
От: Wilton
Дата:
Сообщение: Postgresql number of command