Re: trigger for pg_authid

Поиск
Список
Период
Сортировка
От Kenneth Downs
Тема Re: trigger for pg_authid
Дата
Msg-id 45CC8C15.6050406@secdat.com
обсуждение исходный текст
Ответ на trigger for pg_authid  ("Diego de Blas" <diego.deblasm@gmail.com>)
Список pgsql-general
Diego de Blas wrote:
> Hello,
>
> I'm trying to set a new trigger for "pg_authid" connected as
> "postgres" but system returns always the same error "Permission
> denied: "pg_authid" is a system catalog"... I have checked privileges
> and I can teorically add new triggers. I don't know whta's wrong...
>
> Thanks

We went the other way with this.  We created our own table of users, and
put a trigger on that so that INSERTS to that table created new users in
postgres, plus anything else we needed to happen.  We did the same with
a table of user-group membership.

Вложения

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