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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment