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

Can't select from SYS.SYSUSERS if you use a WHERE clause in the query

    XMLWordPrintableJSON

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Seen in production

      Description

      The following query runs fine:

      SELECT username, lastmodified FROM sys.sysusers;

      ...but the following query raises an exception:

      SELECT username, lastmodified FROM sys.sysusers WHERE USERNAME = 'FRED';

      ...which is

      ERROR 4251E: No one can view the 'SYSUSERS'.'PASSWORD' column.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rhillegas Rick Hillegas
                Reporter:
                rhillegas Rick Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: