db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: SYSTEMALIAS flag in SYSALIASES table
Date Thu, 09 Mar 2006 15:22:35 GMT


Daniel John Debrunner wrote:

>What's the effect of the EXTERNAL SECURITY INVOKER/OWNER flag when the
>sql standard grant/revoke mode is not enabled?
>
>Will the EXTERNAL SECURITY INVOKER/OWNER clauses be accepted on the
>CREATE FUNCTION/PROCEDURE when the sql standard grant/revoke mode is not
>enabled?
>  
>
Current functional spec is not clear on this... sqlStandard mode has
DEFINER as the default if not specified and non sqlStandard mode uses
INVOKER model. It may be best to not allow this flag in current mode.
Also non sqlStandard mode will not support DEFINER mode.

Satheesh

>Dan.
>
>
>
>  
>


Mime
View raw message