Hello, I have a question regarding user rights. I have one user in postgres8.01. which connects from a webserver and inserts some data into a table. It only has INSERT access on that table. ON the other hand, on the same table a have an after-insert trigger which executes a function owned by a more powerful user. My problem is that when I try to insert some data with the webserver user, PostgreSQL wants that user to have access to all the relations used in the trigger function. Is there any way to avoid granting the light user with all those rigths? Thank you very much! -- Cu respect, Valentin Militaru Telcor Communications Tel: 0316.900.015 Tel.Mobil:0741.168.267 Fax: 0316.900.001 Prezentul mesaj si orice fisier atasat constituie informatie confidentiala si este proprietatea exclusiva a Telcor Communications SRL. Mesajul se adreseaza numai persoanei fizice sau juridice mentionata ca destinatara, precum si persoanelor autorizate sa-l primeasca. In cazul in care nu sunteti destinatarul vizat sau persoana autorizata sa primiti acest mesaj, va aducem la cunostinta ca dezvaluirea, copierea, distribuirea sau initierea unor actiuni pe baza prezentei informatii sunt strict interzise si atrag raspunderea dvs. civila si penala. Daca ati primit acest mesaj dintr-o eroare, va rugam sa ne anuntati imediat si sa-l stergeti apoi din sistemul dvs. Nu putem garanta ca transmisia acestui mesaj este securizata sau fara erori.
