From: Luis Sousa <llsousa@ualg.pt>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Permission on insert rules
Date: Wed, 13 Nov 2002 15:09:26 +0000
Message-ID: <3DD26B26.3010100@ualg.pt> (raw)
References: <web-1822655@davinci.ethosmedia.com>
<1037137215.27220.64.camel@camel>
<3DD22D03.4090505@ualg.pt>
<21306.1037197621@sss.pgh.pa.us>
Tom Lane wrote:
>Luis Sousa <llsousa@ualg.pt> 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
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: llsousa@ualg.pt, tgl@sss.pgh.pa.us, xzilla@users.sourceforge.net, josh@agliodbs.com
Subject: Re: Permission on insert rules
In-Reply-To: <3DD26B26.3010100@ualg.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox