pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Setuid functions
2+ messages / 2 participants
[nested] [flat]

* Setuid functions
@ 2003-07-08 16:29  Luis Sousa <llsousa@ualg.pt>
  0 siblings, 1 reply; 2+ messages in thread

From: Luis Sousa @ 2003-07-08 16:29 UTC (permalink / raw)
  To: pgsql-sql

Hi all,

How can I set a function as setuid ?
I take a look at the documetation, on Reference Manual and the only 
reference I saw to it was on SET SESSION AUTHORIZATION.

Thanks in advance.
Luis Sousa




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Setuid functions
@ 2003-07-08 16:34  Joe Conway <mail@joeconway.com>
  parent: Luis Sousa <llsousa@ualg.pt>
  0 siblings, 0 replies; 2+ messages in thread

From: Joe Conway @ 2003-07-08 16:34 UTC (permalink / raw)
  To: Luis Sousa <llsousa@ualg.pt>; +Cc: pgsql-sql

Luis Sousa wrote:
> How can I set a function as setuid ?
> I take a look at the documetation, on Reference Manual and the only 
> reference I saw to it was on SET SESSION AUTHORIZATION.

See:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-createfunction.html

CREATE [ OR REPLACE ] FUNCTION name ( [ argtype [, ...] ] )
      RETURNS rettype
    { LANGUAGE langname
      | IMMUTABLE | STABLE | VOLATILE
      | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
      | [EXTERNAL] SECURITY INVOKER | [EXTERNAL] SECURITY DEFINER
      | AS 'definition'
      | AS 'obj_file', 'link_symbol'
    } ...
      [ WITH ( attribute [, ...] ) ]


[EXTERNAL] SECURITY INVOKER
[EXTERNAL] SECURITY DEFINER

     SECURITY INVOKER indicates that the function is to be executed with 
the privileges of the user that calls it. That is the default. SECURITY 
DEFINER specifies that the function is to be executed with the 
privileges of the user that created it.

     The key word EXTERNAL is present for SQL compatibility but is 
optional since, unlike in SQL, this feature does not only apply to 
external functions.

HTH,

Joe




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-07-08 16:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-08 16:29 Setuid functions Luis Sousa <llsousa@ualg.pt>
2003-07-08 16:34 ` Joe Conway <mail@joeconway.com>

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