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 "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/09/07 18:08:22 UTC

[jira] Created: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
--------------------------------------------------------------------------------------------

                 Key: DERBY-1824
                 URL: http://issues.apache.org/jira/browse/DERBY-1824
             Project: Derby
          Issue Type: Improvement
          Components: SQL
            Reporter: Daniel John Debrunner
            Priority: Minor


E.g.

ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

should be

ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12567559#action_12567559 ] 

Jørgen Løland commented on DERBY-1824:
--------------------------------------

Hi Jazarine,

This is the same error. The error code was changed as part of DERBY-1828

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal resolved DERBY-1824.
-----------------------------------

    Resolution: Fixed

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Dyre Tjeldvoll updated DERBY-1824:
----------------------------------

    Derby Info:   (was: [Patch Available])

Committed revision 629024. 

Thank you for your contribution!

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal commented on DERBY-1824:
---------------------------------------

I tried reproducing this error.
I created two users and created a table for one of the user ME.

I revoked the select privilege from the second user.

i got the same error but with a different error code:ERROR 42502.
This is the error message that i got:

ERROR 42502: User 'ME2' does not have select permission on column 'SS' of table 'ME'.'METEST'.

Is this is the same error or different?




> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

Posted by "Deepthi Devaki A R (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12568962#action_12568962 ] 

Deepthi Devaki A R commented on DERBY-1824:
-------------------------------------------

My system hung during the junit test: suites.all for this patch.
Can anyone in the community run the suites.all test with this patch applied?

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal updated DERBY-1824:
----------------------------------

    Attachment: DERBY1824.diff

I made changes to java/engine/org/apache/derby/iapi/sql/dictionary/StatementTablePermission.java

The diff file has been attached. Please have look.

I am running the junit tests for this fix.

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal updated DERBY-1824:
----------------------------------

    Derby Info: [Patch Available]

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal reassigned DERBY-1824:
-------------------------------------

    Assignee: Jazarine Jamal

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal commented on DERBY-1824:
---------------------------------------

I made some changes in the StatementTablePermission.java...in the function getPrivName.

In the function, there are the privlege names in lowercase. I changed them to UPPERCASE.
I build the code and then tested it with the ij tool.

The required change is found.

I'm doing the junit functional tests for this now.

Please comment.

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Deepthi Devaki A R updated DERBY-1824:
--------------------------------------

    Comment: was deleted

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-1824) Permission/privlege names in exceptions should be in upper case as keywords, not lower case.

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

Jazarine Jamal commented on DERBY-1824:
---------------------------------------

I built the  project with the ccode change.

Then, i reproduced the same error and the required change has been reflected.

> Permission/privlege names in exceptions should be in upper case as keywords, not lower case.
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1824
>                 URL: https://issues.apache.org/jira/browse/DERBY-1824
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Assignee: Jazarine Jamal
>            Priority: Minor
>         Attachments: DERBY1824.diff
>
>
> E.g.
> ERROR 28508: User 'MAMTA3' does not have select permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.
> should be
> ERROR 28508: User 'MAMTA3' does not have SELECT permission on column 'C111' of table 'MAMTA2'.'V21VIEWTEST'.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.