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

    • Normal
    • Repro attached
    • 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

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: