db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-3906) SQL roles: add caching of the role grant graph for performance
Date Sun, 30 Sep 2012 02:32:07 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Mamta A. Satoor updated DERBY-3906:

    Urgency: Normal
     Labels: derby_triage10_10  (was: )
> SQL roles: add caching of the role grant  graph for performance
> ---------------------------------------------------------------
>                 Key: DERBY-3906
>                 URL: https://issues.apache.org/jira/browse/DERBY-3906
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Dag H. Wanvik
>            Priority: Minor
>              Labels: derby_triage10_10
> In the first implementation, the graph of the grant role relation is built as needed.
> For DDL statements this is acceptable, but less less so for the following case:
> When a session changes it's role from a non-null role ("old role"), any activations
> of prepared statements that relied on a role in "old role"s grant closure will need re-checking.
> So, computing this, requires the grant graph. Setting a role is a more frequent operations,
> e.g. in a stored routine, so re-building the grant graph each time is (too) expensive.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message