Derby
  1. Derby
  2. DERBY-5334

Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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'.

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

        Activity

        Gavin made changes -
        Workflow jira [ 12620426 ] Default workflow, editable Closed status [ 12796897 ]
        Kim Haase made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Myrna van Lunteren made changes -
        Fix Version/s 10.8.2.2 [ 12317968 ]
        Fix Version/s 10.8.2.0 [ 12317955 ]
        Myrna van Lunteren made changes -
        Fix Version/s 10.8.2.0 [ 12317955 ]
        Fix Version/s 10.8.1.6 [ 12316676 ]
        Kim Haase made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info [Patch Available]
        Fix Version/s 10.8.1.6 [ 12316676 ]
        Fix Version/s 10.9.0.0 [ 12316344 ]
        Resolution Fixed [ 1 ]
        Kim Haase made changes -
        Issue & fix info [Patch Available]
        Kim Haase made changes -
        Attachment DERBY-5334.diff [ 12486495 ]
        Attachment rrefsetuseraccess.html [ 12486496 ]
        Kim Haase made changes -
        Field Original Value New Value
        Assignee Kim Haase [ chaase3 ]
        Rick Hillegas created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development