GTW JDBC IdP
Was this helpful?
Was this helpful?
Path: Client Management > GTW JDBC IdP
In this section, you can find instructions on how to maintain the JDBC authentication servers using the gateway.
To search for GTW JDBC IdP, you can search using the relevant information as keywords.
Users can create, update, view details, and delete the clients.
Click Create to access the JDBC IdP Client creation page.
Fill in the data or make selections as instructed below. The fields marked with “*” are required.
Enable*: This account is active (Y) or inactive (N).
Page Title*: Header of the login page.
Icon: Click Choose file to select and upload an identifiable GTW JDBC IdP image. If no image is uploaded, the system will automatically use the digiRunner logo.
Connection Name*: A name or label used in many software applications to identify a specific database, network connection, or other resource connection. It is an easy-to-remember name used to identify and manage different connections. You can create a Connection Name in RDB Connection.
SQL (Prepare Statement)*: A mechanism used in programming languages to execute pre-prepared SQL statements. This technique enhances database operation security and performance by preprocessing and parameterizing SQL statements.
SQL Parameters*: Special markers used to pass values into SQL statements during execution. These parameters prevent SQL injection attacks, improve code readability and maintainability, and enhance database query performance. Before executing the SQL query, the parameters need to be bound or set with actual values. This helps separate the structure of the SQL statement from the data values and prevents attacks on the database from malicious user input.
User Secret Algorithm*: An encryption or hashing algorithm used to protect user passwords or sensitive information. When user passwords are saved in the system, a specific algorithm is often used to encrypt or hash them to ensure security.
User Secret Column Name*: The column name in the database table used to save user passwords or sensitive information. When designing the database structure to save user account information, the password is usually saved as an important piece of sensitive information.
ID Token.sub Column Name*: For passing user's identity information to the client during the authentication process. The .sub field is usually used to represent the user's unique identifier to distinguish between different users.
ID Token.name Column Name: For passing user's identity information to the client during the authentication process. The .name field is usually used to represent the user's name or display name.
ID Token.email Column Name: For passing user's identity information to the client during the authentication process. The .email field is usually used to represent the user's email address.
ID Token.picture Column Name: For passing user's identity information to the client during the authentication process. The .picture field is typically used to represent the user's avatar or picture.
Access and view the JDBC IdP client details.
Modify the desired fields, and click Update to save and exit.
A warning prompt displaying the message “Confirm Delete?” will pop up. Click Confirm to delete this JDBC IdP Client and exit.
To view the details of GTW JDBC IdP, you can search using the relevant information as keywords, and click on the icon to access the GTW JDBC IdP Client List page.
To view the details of the JDBC IdP client, search for the client you want to view, and click on theicon.
To update an JDBC IdP Client, search for the client you want to modify, and click on the icon to access the Update page.
Select the client ID to delete, and click on the icon to proceed.
