You said users, did you mean users' or user's ?

For the current user, look at the function SYS_CONTEXT in the SQL manual, otherwise v$session is a start.