[ 
https://issues.apache.org/jira/browse/DERBY-4680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12918947#action_12918947
 ] 

Dag H. Wanvik commented on DERBY-4680:
--------------------------------------

Thanks, Kim! This looks great now. 
One more thing: in the rrefcallprocedure.dita, we now spell out what happens to 
current schema and current role when running with definer's right. We are not 
so explicit about what happens when invoking a routine with invoker's rights 
(the default) and what happens on return.

Maybe, to be clear, we should add a sentence or two about that here, too. E.g.

"When a procedure with invoker's's rights is called, the current default 
schema, current role is unchanged initially within the procedure.
Similarly, if SQL authorization mode is not enabled, the current default schema 
is unchanged initially within the procedure.

When returning from the call, any changes made inside the procedure to default 
current schema (and current role if relevant) are reset (popped)."

It also just struck me that the functions call documentation should also be 
updated with definer's rights, so we should probably duplicate the information 
in this section (replacing procedure with function) somwhere...?




> Add documentation for routines running with definer's rights
> ------------------------------------------------------------
>
>                 Key: DERBY-4680
>                 URL: https://issues.apache.org/jira/browse/DERBY-4680
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>             Fix For: 10.7.0.0
>
>         Attachments: DERBY-4680-2.diff, DERBY-4680-2.stat, DERBY-4680-2.zip, 
> DERBY-4680.diff, DERBY-4680.stat, DERBY-4680.zip
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to