How to prevent users from doing manually what my trigger should do for them?

Поиск
Список
Период
Сортировка
От thomharp@charter.net (Thom Harp)
Тема How to prevent users from doing manually what my trigger should do for them?
Дата
Msg-id 8d8b43c3.0303171602.560f9fcb@posting.google.com
обсуждение исходный текст
Ответы Re: How to prevent users from doing manually what my trigger should do for them?  (greg@turnstep.com)
Список pgsql-general
I have a trigger which inserts a row into a table (table A) based on
what a user inserts into a different table (table B).  To allow this,
the user needs insert permission for table A in order for the trigger
to run.  Is there a way I can restrict this so the user only has
permission to insert via the trigger and not manually?  I can't trust
my users to insert correct values into table A by themselves but I
need them to be able to run the trigger.

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

Предыдущее
От: CoL
Дата:
Сообщение: Re: postgreSQL as MSSQL2000 server?
Следующее
От: "Kev Martin"
Дата:
Сообщение: newbie going round in circle