SYSLOGIN system table

Reference Manual
CHAPTER 15. System Tables

SYSLOGIN system table

Column name

Column type

Column constraint

Table constraints

integrated_login_id

CHAR(128)

NOT NULL

Primary key,

login_uid

SMALLINT

NOT NULL

Foreign key references SYS.SYSLOGIN. user_id.

remarks

LONG, VARCHAR

Column name	Column type	Column constraint	Table constraints
integrated_login_id	CHAR(128)	NOT NULL	Primary key,
login_uid	SMALLINT	NOT NULL	Foreign key references SYS.SYSLOGIN. user_id.
remarks	LONG, VARCHAR

This table contains all the User Profile names that can be used to connect to the database using an integrated logon. As a security measure, only users with DBA authority can view the contents of this table.

integrated_login_id A string value containing the User Profile name that is used to map to a user ID in the database. When a user successfully logs on using this User Profile name, and the database is enabled to accept integrated logons, the user can connect to the database without providing a user ID or password.

login_uid A foreign key to the system table SYSUSERPERM.

remarks A comment string