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

        Rick Hillegas created issue -
        Kim Haase made changes -
        Field Original Value New Value
        Assignee Kim Haase [ chaase3 ]
        Hide
        Kim Haase added a comment -

        Attaching DERBY-5334.diff and rrefsetuseraccess.html, containing the recommended fix to the SYSCS_UTIL.SYSCS_SET_USER_ACCESS topic.

        Show
        Kim Haase added a comment - Attaching DERBY-5334 .diff and rrefsetuseraccess.html, containing the recommended fix to the SYSCS_UTIL.SYSCS_SET_USER_ACCESS topic.
        Kim Haase made changes -
        Attachment DERBY-5334.diff [ 12486495 ]
        Attachment rrefsetuseraccess.html [ 12486496 ]
        Kim Haase made changes -
        Issue & fix info [Patch Available]
        Hide
        Rick Hillegas added a comment -

        Thanks, Kim. Looks good to me. +1

        Show
        Rick Hillegas added a comment - Thanks, Kim. Looks good to me. +1
        Hide
        Kim Haase added a comment -

        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.

        Show
        Kim Haase added a comment - 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.
        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 ]
        Myrna van Lunteren made changes -
        Fix Version/s 10.8.2.0 [ 12317955 ]
        Fix Version/s 10.8.1.6 [ 12316676 ]
        Myrna van Lunteren made changes -
        Fix Version/s 10.8.2.2 [ 12317968 ]
        Fix Version/s 10.8.2.0 [ 12317955 ]
        Hide
        Kim Haase added a comment -

        Issue was resolved several months ago, so closing.

        Show
        Kim Haase added a comment - Issue was resolved several months ago, so closing.
        Kim Haase made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 12620426 ] Default workflow, editable Closed status [ 12796897 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        2h 8m 1 Kim Haase 14/Jul/11 21:07
        Resolved Resolved Closed Closed
        217d 17h 59m 1 Kim Haase 17/Feb/12 15:06

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development