Filtering a table based on multiple values of a single column
Sure, you are looking for the IN condition. 

https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions013.htm

SELECT UserID, Attributes, UserPrivileges, 1stName, 2ndName
FROM User
WHERE 1stName IN ('John', 'Jane', 'Joseph', 'Laura');