db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DERBY-5334) Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS
Date Thu, 14 Jul 2011 21:08:59 GMT

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

Kim Haase resolved DERBY-5334.
------------------------------

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

Thanks very much for the prompt review, Rick!

Committed patch DERBY-5334.diff to documentation trunk at revision 1146887. 
Merged to 10.8 doc branch at revision 1146895.

> Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS
> -------------------------------------------------------------------------
>
>                 Key: DERBY-5334
>                 URL: https://issues.apache.org/jira/browse/DERBY-5334
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.9.0.0
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>             Fix For: 10.8.1.6, 10.9.0.0
>
>         Attachments: DERBY-5334.diff, rrefsetuseraccess.html
>
>
> The Reference Guide topic for SYSCS_UTIL.SYSCS_SET_USER_ACCESS incorrectly states that
the permissions are
>   fullAcess
>   readOnlyAccess
> You will get an error if you try to set those permissions. The actual permissions are
>   FULLACCESS
>   READONLYACCESS
> The following script shows this problem:
> ij> connect 'jdbc:derby:memory:db;create=true;user=admin;password=adminpassword' as
admin_conn;
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'READONLYACCESS');
> 0 rows inserted/updated/deleted
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'FULLACCESS');
> 0 rows inserted/updated/deleted
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', null );
> 0 rows inserted/updated/deleted
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'readOnlyAccess');
> ERROR XCZ00: Unknown permission 'readOnlyAccess'.
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'fullAccess');
> ERROR XCZ00: Unknown permission 'fullAccess'.

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

        

Mime
View raw message