Create user trigger?
От | Glyn Astill |
---|---|
Тема | Create user trigger? |
Дата | |
Msg-id | 501266.73767.qm@web25812.mail.ukl.yahoo.com обсуждение исходный текст |
Ответы |
Re: Create user trigger?
|
Список | pgsql-general |
Hi Chaps, We're setting up 3 servers replicating using slony. I was wondering if it'd be possible for me to create a set of triggersthat fire whenever a user is created/dropped/modified on one of the servers that goes and performs the same actionthe other two servers. Does that sound doable? I'm not sure what the implications of doing this would be, and I'mm not sure the best way to do it.... But this is what Iwas thinking of doing: Have a user table containing all the usernames, and every time a user is inserted/deleted from the table create/drop theuser using a trigger. Then put the table in replication using slony. Obviously I'd have to drop and then recreate the users when I wanted to alter them, and I'd have to meke sure permissionswere set properly to the table. Are there any better alternatives? Thanks ___________________________________________________________ Rise to the challenge for Sport Relief with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/
В списке pgsql-general по дате отправления: