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