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
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.
-
You can reply to this email to add a comment to the issue online.
