EXA_USER_USERS

This table provides detailed information about the user currently logged in. All users have access to the table.

Column Name Description
USER_NAME Name of the user
CREATED Time when the user was created
USER_CONSUMER_GROUP Consumer Group of the user
PASSWORD_STATE State of the password (VALID, EXPIRED(GRACE) or EXPIRED)
PASSWORD_STATE_CHANGED Timestamp when the password state has changed, either by password change or by password expiry
PASSWORD_EXPIRY Timestamp when the password will expire or has been expired (if NULL, the password will never expire)
PASSWORD_EXPIRY_DAYS Number of days after which the user password expires after the last password change (if NULL, the password will never expire)
PASSWORD_GRACE_DAYS Number of days within the user has to change the password after it has expired (if NULL, there is no grace period and the user will directly be blocked from login after the expiry)
PASSWORD_EXPIRY_POLICY User-specific expiry policy as specified via ALTER USER command, overwriting the corresponding global system parameter
FAILED_LOGIN_ATTEMPTS Number of failed login attempts by the user since last successful login
USER_COMMENT Comment on the user