Derby
  1. Derby
  2. DERBY-5404

Document DBO restriction for four diagnostic VTIs

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.2.2, 10.9.1.0
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      DERBY-5395 restricts access to these four diagnostic tables/functions to the database owner:

      syscs_diag.statement_cache
      syscs_diag.transaction_table
      syscs_diag.error_log_reader( )
      syscs_diag.statement_duration()

      The topic "SYSCS_DIAG diagnostic tables and functions" should include this information.

      1. DERBY-5404.diff
        5 kB
        Kim Haase
      2. DERBY-5404-2.diff
        7 kB
        Kim Haase
      3. rrefsyscsdiagtables.html
        23 kB
        Kim Haase
      4. rrefsyscsdiagtables.html
        23 kB
        Kim Haase

        Issue Links

          Activity

          Kim Haase created issue -
          Kim Haase made changes -
          Field Original Value New Value
          Link This issue blocks DERBY-5395 [ DERBY-5395 ]
          Kim Haase made changes -
          Link This issue blocks DERBY-5395 [ DERBY-5395 ]
          Kim Haase made changes -
          Link This issue depends on DERBY-5395 [ DERBY-5395 ]
          Hide
          Kim Haase added a comment -

          Attaching DERBY-5404.diff and rrefsyscsdiagtables.html, reflecting changes to

          M src/ref/rrefsyscsdiagtables.dita

          I added a sentence to each topic and also took the liberty of correcting the spelling of "snapshot".

          Please let me know if the language needs tweaking.

          Show
          Kim Haase added a comment - Attaching DERBY-5404 .diff and rrefsyscsdiagtables.html, reflecting changes to M src/ref/rrefsyscsdiagtables.dita I added a sentence to each topic and also took the liberty of correcting the spelling of "snapshot". Please let me know if the language needs tweaking.
          Kim Haase made changes -
          Attachment DERBY-5404.diff [ 12493366 ]
          Attachment rrefsyscsdiagtables.html [ 12493367 ]
          Kim Haase made changes -
          Issue & fix info [Patch Available]
          Hide
          Rick Hillegas added a comment -

          Thanks, Kim. The changes look good. For extra credit we might want to add similar statements to the descriptions of the other diagnostic VTIs, saying that they can be run by anyone even in a database protected by authentication and authorization. Thanks.

          Show
          Rick Hillegas added a comment - Thanks, Kim. The changes look good. For extra credit we might want to add similar statements to the descriptions of the other diagnostic VTIs, saying that they can be run by anyone even in a database protected by authentication and authorization. Thanks.
          Hide
          Kim Haase added a comment -

          Thanks, Rick! I've incorporated your suggestion in this second patch, DERBY-5404-2.diff, and updated the output file. I hope the new language is correct – please let me know if further changes are needed.

          Show
          Kim Haase added a comment - Thanks, Rick! I've incorporated your suggestion in this second patch, DERBY-5404 -2.diff, and updated the output file. I hope the new language is correct – please let me know if further changes are needed.
          Kim Haase made changes -
          Attachment DERBY-5404-2.diff [ 12493599 ]
          Attachment rrefsyscsdiagtables.html [ 12493600 ]
          Hide
          Rick Hillegas added a comment -

          Looks great. Thanks, Kim. +1

          Show
          Rick Hillegas added a comment - Looks great. Thanks, Kim. +1
          Hide
          Kim Haase added a comment -

          Thanks, Rick.

          Committed patch DERBY-5404-2.diff to documentation trunk at revision 1166780.
          Merged to 10.8 doc branch at revision 1166829.

          Show
          Kim Haase added a comment - Thanks, Rick. Committed patch DERBY-5404 -2.diff to documentation trunk at revision 1166780. Merged to 10.8 doc branch at revision 1166829.
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info [Patch Available]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Affects Version/s 10.8.2.0 [ 12317955 ]
          Affects Version/s 10.8.1.6 [ 12316676 ]
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Hide
          Kim Haase added a comment -

          Fixes have appeared in latest alpha manuals.

          Show
          Kim Haase added a comment - Fixes have appeared in latest alpha manuals.
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Myrna van Lunteren made changes -
          Affects Version/s 10.8.2.2 [ 12317968 ]
          Affects Version/s 10.8.2.0 [ 12317955 ]
          Fix Version/s 10.8.2.2 [ 12317968 ]
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Mike Matrigali made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Mike Matrigali made changes -
          Component/s Documentation [ 11406 ]
          Mike Matrigali made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Hide
          Kim Haase added a comment -

          Thanks for updating the component, Mike.

          Show
          Kim Haase added a comment - Thanks for updating the component, Mike.
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Link This issue depends on DERBY-5395 [ DERBY-5395 ]
          Gavin made changes -
          Link This issue depends upon DERBY-5395 [ DERBY-5395 ]
          Gavin made changes -
          Workflow jira [ 12631608 ] Default workflow, editable Closed status [ 12801173 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Resolved Resolved
          1d 56m 1 Kim Haase 08/Sep/11 19:12
          Closed Closed Reopened Reopened
          149d 7h 2m 1 Mike Matrigali 16/Feb/12 20:37
          Reopened Reopened Resolved Resolved
          20s 1 Mike Matrigali 16/Feb/12 20:37
          Resolved Resolved Closed Closed
          12d 13h 54m 2 Kim Haase 17/Feb/12 15:10

            People

            • Assignee:
              Kim Haase
              Reporter:
              Kim Haase
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development