Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1539

A trigger should be dropped when a privilege required by the trigger is revoked.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.2.1.6
    • 10.2.1.6
    • SQL
    • None
    • Normal

    Description

      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.

      See the functional spec attached to DERBY-1330

      Attachments

        1. DERBY1539V1hashCodeEqualsDiff.txt
          11 kB
          Mamta A. Satoor
        2. DERBY1539V1hashCodeEqualsStat.txt
          0.4 kB
          Mamta A. Satoor
        3. DERBY1539V2diffDropTriggerOnRevoke.txt
          24 kB
          Mamta A. Satoor
        4. DERBY1539V2statDropTriggerOnRevoke.txt
          0.8 kB
          Mamta A. Satoor
        5. DERBY1539V3diffDropTriggerOnRevoke.txt
          30 kB
          Mamta A. Satoor
        6. DERBY1539V3statDropTriggerOnRevoke.txt
          1 kB
          Mamta A. Satoor
        7. DERBY1539V4diffDropTriggerOnRevoke.txt
          30 kB
          Mamta A. Satoor
        8. DERBY1539V4diffDropTriggerOnRevokeRequiredPrivilege.txt
          78 kB
          Mamta A. Satoor
        9. DERBY1539V4statDropTriggerOnRevokeRequiredPrivilege.txt
          2 kB
          Mamta A. Satoor

        Issue Links

          is blocked by

          Sub-task - The sub-task of the issue DERBY-1057 documentation to address Grant/Revoke (Derby-464)

          • Major - Major loss of function.
          • Closed
          is part of

          Sub-task - The sub-task of the issue DERBY-1330 Provide runtime privilege checking for grant/revoke functionality

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-1782 When a privilege is revoked at table level, Derby should only drop objects that require that particular privilege and not all the objects that require some form of privilege on that table.

          • Major - Major loss of function.
          • Open

          Activity

            People

              mamtas Mamta A. Satoor
              mamtas Mamta A. Satoor
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: