Contents Index SYSJAVACLASS system table SYSOPTBLOCK system table

ASA SQL Reference
  System Tables

SYSLOGIN system table


Column name Column type Column constraint Table constraints
integrated_login_id CHAR(128) NOT NULL Primary key
login_uid UNSIGNED INT NOT NULL Foreign key references SYSUSERPERM.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


Contents Index SYSJAVACLASS system table SYSOPTBLOCK system table