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] [Assigned] (DERBY-5334) Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS
Date Thu, 14 Jul 2011 19:26:00 GMT

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

Kim Haase reassigned DERBY-5334:
--------------------------------

    Assignee: Kim Haase

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