[jira] Commented: (DERBY-1825) Errors 2850A,2850G,28508 are similar - can be combined into a single message.

["Jørgen Løland (JIRA)" <ji...@apache.org>]

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

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

I have looked into all the '28'-error messages. I suggest that
the following similar errors are combined:

Errors 28506, 2850A and 2850G replaced by:
<msg>   
    <name>28506</name>
    <text>User '{0}' does not have {1} permission on {2} '{3}'.'{4}'.</text>
    <arg>authorizationID</arg>
    <arg>permissionName</arg>
    <arg>objectType</arg>
    <arg>schemaName</arg>
    <arg>objectName</arg>
</msg>

Errors 28507 and 2850B replaced by:
<msg>
    <name>28507</name>
    <text>User '{0}' does not have {1} permission on {2} '{3}'.'{4}' for grant.</text>
    <arg>authorizationID</arg>
    <arg>permissionType</arg>
    <arg>objectType</arg>
    <arg>schemaName</arg>
    <arg>tableName</arg>
</msg>

Errors 2850E, 2850H.C, 2850I.C and 2850J.C replaced by
<msg>
    <name>2850E</name>
    <text>User '{0}' cannot {1} {2} '{3}'. Only the database owner can perform this operation.</text>
    <arg>authorizationID</arg>
    <arg>operationType</arg>
    <arg>objectType</arg>
    <arg>objectName</arg>
</msg>


Jørgen Løland


> 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
>
> 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.