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

Incorrect privileges may be required for INSERT and DELETE statements.

    XMLWordPrintableJSON

Details

    • Normal
    • Release Note Needed
    • Deviation from standard

    Description

      This issue is a place to address problems with INSERT and DELETE statements similar to the problems affecting UPDATE statements recorded on DERBY-6429. In particular, DERBY-6432 and DERBY-6433 list some of the problems with INSERT statements.

      Attachments

        1. derby-6434-01-aa-correctInsertPrivs.diff
          15 kB
          Richard N. Hillegas
        2. derby-6434-01-ac-correctInsertPrivs.diff
          17 kB
          Richard N. Hillegas
        3. derby-6434-02-ac-correctDeletePrivs.diff
          20 kB
          Richard N. Hillegas
        4. derby-6434-03-ac-testCaseForDerby-6432.diff
          4 kB
          Richard N. Hillegas
        5. derby-6434-04-aa-dontNeedPrivOnGeneratedColumnTypeForInsert.diff
          6 kB
          Richard N. Hillegas
        6. derby-6434-05-aa-selectDrivenInserts.diff
          8 kB
          Richard N. Hillegas
        7. releaseNote.html
          2 kB
          Richard N. Hillegas

        Issue Links

          is related to

          Task - A task that needs to be done. DERBY-6449 Analyze and possibly correct the suspicious addition of in-memory dependencies during statement execution

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. DERBY-6481 Derby 10.10 backport issue (winter/spring 2014)

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

          Sub-task - The sub-task of the issue DERBY-6431 Update Developer's Guide topic to include generated columns

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6429 Privilege checks for UPDATE statements are wrong.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6432 INSERT/UPDATE incorrectly require user to have privilege to execute CHECK constraints on the target table.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6433 INSERT/UPDATE incorrectly require user to have privilege to run generation expressions.

          • Major - Major loss of function.
          • Closed

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: