Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Execute permissions for stored functions
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Paul Hart <paulhart(at)redchocolate(dot)ca>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Execute permissions for stored functions
- Date: Mon, 19 Jan 2004 00:40:33 -0500
- Message-id: <20956.1074490833@sss.pgh.pa.us> <text/plain>
Paul Hart <paulhart(at)redchocolate(dot)ca> writes: > In RDBMSs such as Oracle, stored PL/SQL functions run with the > permissions of the user that creates the function. Users who are given > EXECUTE privileges then call the function with the permissions of the > creator of the function. Use "SECURITY DEFINER" to get this behavior in Postgres. The SQL99 spec punts as to whether SECURITY DEFINER should be the default or not, so unfortunately neither we nor Oracle can be said to be wrong on this point... regards, tom lane
- References:
- Execute permissions for stored functions
- From: Paul Hart
- Execute permissions for stored functions
- Prev by Date: Re: Left joins with multiple tables
- Next by Date: Re: How can I get the last element out of GROUP BY sets?
- Previous by thread: Execute permissions for stored functions
- Next by thread: How can I get the last element out of GROUP BY sets?
- Indexes: