Re: Setuid functions - Mailing list pgsql-hackers

From Mark Volpe
Subject Re: Setuid functions
Date
Msg-id 3B310014.409E1733@epa.gov
Whole thread Raw
In response to Setuid functions  (Mark Volpe <volpe.mark@epamail.epa.gov>)
Responses RE: Setuid functions  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Okay, what I'm thinking is to have a pair of commands added to PL/pgSQL. For
the sake of example we'll call them:

ENABLE PRIVLEDGE  --> Sets user ID to that of the function's owner
DISABLE PRIVLEDGE --> Restores the original UID

I saw something like this being used in the referential integrity code, and
thought this would be a nice (albeit incomplete) way to generalize this
ability.

Mark

Mark Volpe wrote:
> 
> I know this topic was discussed a few months ago, but I'm wondering if any
> decisions have been reached on if, how, and when setuid functions and triggers
> might be implemented. If not, I have an idea to throw at it.
> 
> Thanks,
> Mark
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: RTLD_GLOBAL on openbsd
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Re: [PATCHES] Australian timezone configure option