Re: Truncate Permission

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Truncate Permission
Дата
Msg-id 20070611085905.GA25296@svana.org
обсуждение исходный текст
Ответ на Re: Truncate Permission  ("Ewald Geschwinde" <egeschwinde@gmail.com>)
Ответы Re: Truncate Permission  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-hackers
On Mon, Jun 11, 2007 at 09:40:08AM +0200, Ewald Geschwinde wrote:
> My problem is that some users don't have access to change the structure but
> they wanted to delete all data from the table
> they try truncate - does not work because not the owner
> so they make a delete from a really big table

Wouldn't it be far more logical to decide that if a user has the
permissions to do a DELETE FROM table; then they have permission to do
a TRUNCATE? Why make an additional permission?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: ToDO, support UPDATE/DELETE WHERE CURRENT OF cursor_name in plpgsql
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Truncate Permission