Re: security definer default for some PL languages (SQL/PSM)? - Mailing list pgsql-hackers

>
>Pavel Stehule wrote:
> > SQL/PSM default for SQL procedures are SECURITY DEFINER (like views),
>
>I can't find this in the standard.  Where did you get this information?
>
>--

Jim Melton, SQL's stored procedures, page 43,

next:
blom98sqlpsm:

3.3.1 Access rights to data
By default, the stored routine can access the same data as the creator of 
the routine.
Hence all tables that the creator of a routine can access and/or change can 
also be
accessed and changed by the routine

but I can't find any better info now, so it's can be propably 
implementation-defined.

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/