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

Document DBO restriction for four diagnostic VTIs

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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. rrefsyscsdiagtables.html
        23 kB
        Kim Haase
      3. DERBY-5404-2.diff
        7 kB
        Kim Haase
      4. rrefsyscsdiagtables.html
        23 kB
        Kim Haase

        Issue Links

          Activity

          Hide
          chaase3 Kim Haase added a comment -

          Thanks for updating the component, Mike.

          Show
          chaase3 Kim Haase added a comment - Thanks for updating the component, Mike.
          Hide
          chaase3 Kim Haase added a comment -

          Fixes have appeared in latest alpha manuals.

          Show
          chaase3 Kim Haase added a comment - Fixes have appeared in latest alpha manuals.
          Hide
          chaase3 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
          chaase3 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.
          Hide
          rhillegas Rick Hillegas added a comment -

          Looks great. Thanks, Kim. +1

          Show
          rhillegas Rick Hillegas added a comment - Looks great. Thanks, Kim. +1
          Hide
          chaase3 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
          chaase3 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.
          Hide
          rhillegas 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
          rhillegas 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
          chaase3 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
          chaase3 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.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development