Search Postgresql Archives

Re: trigger for pg_authid

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.
begin:vcard
fn:Kenneth  Downs
n:Downs;Kenneth 
adr;dom:;;347 Main Street;East Setauket;NY;11733
email;internet:ken@xxxxxxxxxx
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
url:http://www.secdat.com
version:2.1
end:vcard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux