Chapter 15 System Tables
1023
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
To Next Page
Loading...