Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » Views » System views

 

SYSUSER system view

Each row in the SYSUSER system view describes a user in the system. Standalone roles are also stored in this view as well, but only the user_id, object_id, user_name, and user_type columns are meaningful for these roles. The underlying system table for this view is ISYSUSER.

Column name Data type Description
user_id UNSIGNED INT A unique identifier for the user assigned to the login policy.
object_id UNSIGNED BIGINT A unique identifier for the user in the database.
user_name CHAR(128) The login name for the user.
password BINARY(128) The password for the user. For security, data in this column is visible only to users with the SELECT ANY TABLE system privilege.
login_policy_id UNSIGNED BIGINT A unique identifier for the login policy.
expired_password_on_login TINYINT A value that indicates if the password for the user expires at the next login.
password_creation_time TIMESTAMP The local time that the password was created for the user.
failed_login_attempts UNSIGNED INT The number of times that a user can fail to log in before the account is locked.
last_login_time TIMESTAMP The local time that the user last logged in.
user_type TINYINT

A value that indicates whether the user is a regular user, or a role, or a user extended as a role. And whether the user, role, or extended role can be altered (mutable) or removed. Possible values:

  • 1   Immutable system role.

  • 5   Mutable system role

  • 9   Immutable and removable system role.

  • 12   Mutable and removable user.

  • 13   Mutable and removable role.

  • 14   Mutable and removable user extended as role.

user_dn CHAR (1024) An LDAP Distinguished Name (DN) identifier for the user that is unique within a domain and across domains. The DN is used to authenticate with an LDAP server.
user_dn_cached_at TIMESTAMP The time that the user_dn column was last cached. This value is used to determine whether to purge an old DN. Regardless of the database server local time zone, the value is stored in Coordinated Universal Time (UTC).
password_creation_time_utc TIMESTAMP WITH TIME ZONE The UTC time that the password was created for the user.
last_login_time_utc TIMESTAMP WITH TIME ZONE The UTC time that the user last logged in.
dual_password BINARY(128) The first and/or second parts of the dual password for the user. For security, data in this column is visible only to users with the SELECT ANY TABLE system privilege.
Note

For databases created using SQL Anywhere 16 or later, the underlying system table for this view is always encrypted to protect the data from unauthorized access.

 Constraints on underlying system table
 See also