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/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
