You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kim Haase (JIRA)" <ji...@apache.org> on 2011/09/07 19:17:10 UTC

[jira] [Created] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Document DBO restriction for four diagnostic VTIs
-------------------------------------------------

                 Key: DERBY-5404
                 URL: https://issues.apache.org/jira/browse/DERBY-5404
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.8.1.6, 10.9.0.0
            Reporter: Kim Haase
            Assignee: Kim Haase


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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13100387#comment-13100387 ] 

Rick Hillegas commented on DERBY-5404:
--------------------------------------

Looks great. Thanks, Kim. +1

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.6, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Mike Matrigali (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali updated DERBY-5404:
----------------------------------

    Component/s: Documentation
    
> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.8.2.2, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>             Fix For: 10.8.2.2, 10.9.0.0
>
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase updated DERBY-5404:
-----------------------------

    Attachment: rrefsyscsdiagtables.html
                DERBY-5404-2.diff

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.

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.6, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13100260#comment-13100260 ] 

Rick Hillegas commented on DERBY-5404:
--------------------------------------

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.

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.6, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>         Attachments: DERBY-5404.diff, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Closed] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase closed DERBY-5404.
----------------------------


Fixes have appeared in latest alpha manuals.

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.2.0, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>             Fix For: 10.8.2.0, 10.9.0.0
>
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase updated DERBY-5404:
-----------------------------

    Attachment: rrefsyscsdiagtables.html
                DERBY-5404.diff

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.

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.6, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>         Attachments: DERBY-5404.diff, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Closed] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Kim Haase (Closed) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase closed DERBY-5404.
----------------------------


Thanks for updating the component, Mike.
                
> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.8.2.2, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>             Fix For: 10.8.2.2, 10.9.0.0
>
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Mike Matrigali (Resolved) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali resolved DERBY-5404.
-----------------------------------

    Resolution: Fixed
    
> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.8.2.2, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>             Fix For: 10.9.0.0, 10.8.2.2
>
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase updated DERBY-5404:
-----------------------------

    Issue & fix info: [Patch Available]

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.6, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>         Attachments: DERBY-5404.diff, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase resolved DERBY-5404.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.9.0.0
                      10.8.1.6
    Issue & fix info:   (was: [Patch Available])

Thanks, Rick. 

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

> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.6, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>             Fix For: 10.8.1.6, 10.9.0.0
>
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Reopened] (DERBY-5404) Document DBO restriction for four diagnostic VTIs

Posted by "Mike Matrigali (Reopened) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Matrigali reopened DERBY-5404:
-----------------------------------

    
> Document DBO restriction for four diagnostic VTIs
> -------------------------------------------------
>
>                 Key: DERBY-5404
>                 URL: https://issues.apache.org/jira/browse/DERBY-5404
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.8.2.2, 10.9.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>             Fix For: 10.8.2.2, 10.9.0.0
>
>         Attachments: DERBY-5404-2.diff, DERBY-5404.diff, rrefsyscsdiagtables.html, rrefsyscsdiagtables.html
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira