I figured out why it is happening! Apparently within the database there are multiple schemas. for some reason it is defaulting to a different one than I was looking at. Two of the schemas (or is it scheme?) have an app_security table with some of the same users I was trying. The ones that weren't in the schema I was using just happened to be longer. So...my question now is how can I specify what schema to use?