db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5334) Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS
Date Thu, 14 Jul 2011 19:00:02 GMT
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


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