Re: function security issue - Mailing list pgsql-general

From [email protected]
Subject Re: function security issue
Date
Msg-id [email protected]
Whole thread Raw
In response to function security issue  ([email protected])
List pgsql-general
> Mike Nolan
> > I have searched the doc, several online books and the mailing list archives
> > without success.  Perhaps I have not hit on the correct keywords.
>
> Check out the 'security definer' vs 'security invoker' clause.
Thanks, that looks like it will do the trick.

I am running Postgres 7.1 from the RPMs that came with my distro, looks like an
upgrade to 7.3 would be required for this syntax.  I will have to look into
that.

I appreciate the quick response.

Regards,
Jason


pgsql-general by date:

Previous
From: [email protected]
Date:
Subject: Re: function security issue
Next
From: Dev
Date:
Subject: C++ and v7.3.2