RE: PV Lists are blank in SL 2011
It still does not make sense. Here is the PV behind the user ID field on the user maintenance screen.
CREATE PROCEDURE
sm_UserRec_UserId
@parm1 varchar(47)
AS
SELECT
*
FROM
UserRec
WHERE
UserId LIKE @parm1
AND
RecType = 'U'
ORDER BY
UserId
From this you can see the only criteria is that the rectype equals U. That table should only have values of U or G in that field and I suspect you have already checked that out. If this were some sort of SQL security issue then you would not be able to open that table at all. As far as I know, there is no record level access control in SQL. And, as you said, the missing user IDs are in the table and, if you enter that ID, the screen populates. Unless there is some sort of restriction logic in the actual screen code that we do not know about, it should be working.\
One thought, when you query the userrec table, order by userid and see if there just might be extra characters or even blank userid records in that userrec table such that the missing names are actually there in the PV list but not in the order expected.