[ 
https://issues.apache.org/jira/browse/DERBY-1825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jørgen Løland updated DERBY-1825:
---------------------------------

    Attachment: DERBY-1825-1.stat
                DERBY-1825-1.diff

It seems that the effect of merging error messages is that either the messages 
get ugly due to the "Table/View" text, or information is lost (if I replace 
"table" with "object" in message 28506). I think this outweighs the positive 
effects achieved by removing 2 or 3 error codes. Hence, I stop working on this 
issue.

I'm attaching a patch for future reference that does what I previously 
described. I.e., error codes 28506, 2850A and 2850G are merged into one error 
message 28506:

   User '{0}' does not have {1} permission on {2} '{3}'.'{4}'. 

Further, error codes 28507 and 2850B are merged into one message 28507:

   User '{0}' does not have {1} permission on {2} '{3}'.'{4}' for grant.

The patch is not intended for inclusion, and has therefore not been tested.

> Errors 2850A,2850G,28508 are similar - can be combined into a single message.
> -----------------------------------------------------------------------------
>
>                 Key: DERBY-1825
>                 URL: https://issues.apache.org/jira/browse/DERBY-1825
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Daniel John Debrunner
>         Assigned To: Jørgen Løland
>         Attachments: DERBY-1825-1.diff, DERBY-1825-1.stat
>
>
> ERROR 2850A: User 'SAM' does not have execute permission on PROCEDURE 
> 'SYSCS_UTIL'.'SYSCS_EXPORT_TABLE'.
> ERROR 2850G: User 'MAMTA2' does not have grant permission on object 
> 'MAMTA2'.'V21VIEWTEST'.
> 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.

Reply via email to