Re: [SQL] Permission on insert rules

[Luis Sousa]

Tom Lane wrote:

Luis Sousa <[EMAIL PROTECTED]> writes:

When inserting, using the rule, the insert that's defined on the rule works fine, but the insert defined inside the function, doesn't (that's the one that gives permssion denied).

Right. As of 7.3 you can fix this by making the function "setuid" (ie,
it runs with the permissions of the function owner, not the caller).

There's any way to insert data inside the tables, using the functions, called by the rules, without giving direct access to the user ?
I don't know, using a trigger or any kind of structure !!??

Regards,
Luis Sousa

smime.p7s

Description: S/MIME Cryptographic Signature