From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
---|---|
To: | peter_e(at)gmx(dot)net, pgsql-hackers(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us |
Subject: | Re: security definer default for some PL languages (SQL/PSM)? |
Date: | 2007-01-07 17:02:18 |
Message-ID: | BAY20-F151FD5D98E1002B1391D6DF9BD0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-07 17:14:06 | Re: [HACKERS] COPY with no WAL, in certain circumstances |
Previous Message | Tom Lane | 2007-01-07 16:47:30 | Re: security definer default for some PL languages (SQL/PSM)? |