Re: Question !

Поиск
Список
Период
Сортировка
От Horst Herb
Тема Re: Question !
Дата
Msg-id 015701c03294$7dbc1280$e7d2fea9@esmith.midgard
обсуждение исходный текст
Ответ на Question !  ("Ruslan P. Yawdoshak" <ra@boy.univ.kiev.ua>)
Список pgsql-general
> Hove i can restrict access for tables in postgeSQL
> and users can anly call function to change tables entries ?
> (In function I'll self control access)

Give all users but one fictive "superuser" read-only access. Write a tier using pqlib as only means to get write access
tothe data base (this tier connects as the fictive "superuser" to the backend). Implement your functions in that tier. 

However, you probably don't want to do that. What you really might want is just writing "before insert or update"
triggersimplementing your functions. That way, no write access will happen before the triggered function has processed
thedata. Am I wrong? 

Horst





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

Предыдущее
От: "He Weiping (Laser Henry)"
Дата:
Сообщение: Is there any caveats on toasted fields?
Следующее
От: tolik@aaanet.ru (Anatoly K. Lasareff)
Дата:
Сообщение: Re: Fake table name?