db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5350) Devguide needs update for definer's rights
Date Fri, 22 Jul 2011 10:42:57 GMT
Devguide needs update for definer's rights

                 Key: DERBY-5350
                 URL: https://issues.apache.org/jira/browse/DERBY-5350
             Project: Derby
          Issue Type: Bug
          Components: Documentation
    Affects Versions:
            Reporter: Knut Anders Hatlen

I found the following in the Using SQL roles topic of the devguide:

"Within stored procedures and functions that contain SQL, the current role is on the authorization
stack. Initially, inside a nested connection, the current role is set to that of the calling

I think this is only correct for procedures running with invoker's rights. For procedures
running with definer's rights, no role is set initially, according to the CREATE PROCEDURE
statement topic in the reference manual:

"When the procedure is first invoked, no role is set; even if the invoker has set a current
role, the procedure running with definer's rights has no current role set initially."

This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message