[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12424753 ] Mamta A. Satoor commented on DERBY-1539: ----------------------------------------
Thinking further about my proposed solution in the comment before this, I think it will be better for dependent descriptors to load their privilege requirements when they receive their first revoke invalidation action. This way, we don't unnecessarily have to load privilege requirements for all the triggers, constraints and view descriptors that get referenced in a database session. Especially, when the SQL Standard Authorization is not enabled, this list is not required at all. So, rather than loading the privilege requirements when the objects get loaded from the data dictionary, load the privilege requirements when the objects receive their first revoke invalidation action. This is all based on my thoughts in last hr or so and hence might have gottchas in them. If anyone catches anything in this solution, please let me know. In the mean time, I will continue to go this path. > As per the functional spec attached to DERBY-1330, a trigger should be > dropped when a privilege required by the trigger is revoked. > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-1539 > URL: http://issues.apache.org/jira/browse/DERBY-1539 > Project: Derby > Issue Type: New Feature > Components: SQL > Affects Versions: 10.2.0.0 > Reporter: Mamta A. Satoor > Assigned To: Mamta A. Satoor > Fix For: 10.2.0.0 > > Attachments: DERBY1539V1hashCodeEqualsDiff.txt, > DERBY1539V1hashCodeEqualsStat.txt, DERBY1539V2diffDropTriggerOnRevoke.txt, > DERBY1539V2statDropTriggerOnRevoke.txt, > DERBY1539V3diffDropTriggerOnRevoke.txt, > DERBY1539V3statDropTriggerOnRevoke.txt, > DERBY1539V4diffDropTriggerOnRevoke.txt, > DERBY1539V4diffDropTriggerOnRevokeRequiredPrivilege.txt, > DERBY1539V4statDropTriggerOnRevokeRequiredPrivilege.txt > > > A trigger tracks its privileges requirements using Derby's Dependency > Manager. If any one of those required privileges are revoked, the trigger > should be dropped automatically. > I am just creating a new jira entry here so it is easier to track sub items > of DERBY-1330. Will link this Jira entry to DERBY-1330. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
