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. rrefsetuseraccess.html
        4 kB
        Kim Haase
      2. DERBY-5334.diff
        1 kB
        Kim Haase

        Activity

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

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development