ASA SQL Reference
System Tables
| 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