Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5334

Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Normal

      Description

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

        Attachments

        1. DERBY-5334.diff
          1 kB
          Kim Haase
        2. rrefsetuseraccess.html
          4 kB
          Kim Haase

          Activity

            People

            • Assignee:
              chaase3 Kim Haase
              Reporter:
              rhillegas Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: