ALL_USERS v16

The ALL_USERS view provides information on all user names.

NameTypeDescription
usernameTEXTName of the user.
user_idOIDNumeric user id assigned to the user.
createdDATETimestamp for when an object was created.
last_ddl_timeDATETimestamp for the last modification of an object resulting from a DDL statement, including grants and revokes.