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

Incorrect privileges may be required for INSERT and DELETE statements.

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

          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:

              Slack

                Issue deployment