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

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

    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

            People

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

              Dates

                Created:
                Updated:
                Resolved: