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

Native user authentication: syscs_util.syscs_create_user allows too long user names

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 10.9.1.0
    • None
    • Services
    • None
    • Security

    Description

      Derby has a limit on the length of the user ids of 30, cf Limits.java: DB2_MAX_USERID_LENGTH.
      However, the new SYSCS_UTIL.SYSCS_CREATE_USER accepts user ids that are longer. Unfortunately, they cannot be used for authentication.
      Cf repro attached.

      Attachments

        1. 5744.sql
          0.8 kB
          Richard N. Hillegas
        2. TestMaxUserIdSize.java
          2 kB
          Dag H. Wanvik

        Issue Links

        relates to

        Improvement - An improvement or enhancement to an existing feature or task. DERBY-866 Derby User Management Enhancements

        • Major - Major loss of function.
        • Closed

        Improvement - An improvement or enhancement to an existing feature or task. DERBY-3146 Adjust length restriction on user identifiers (authorization ids) to same as other identifiers

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            dagw Dag H. Wanvik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment