External Table Authentication

1) First create a table with username, password, and group_name

Fig( 1) : Data base table login_auth

Open your rpd

2. Select Manage > Variables to open the Variable Manager.

3. Select Initialization Blocks on the left tree pane.

4. Right-click on white space in the right pane, and then click on New Initialization Block from the right-click menu.

5. In the Initialization Block dialog box, type the name for the initialization block.

6. Select Database from the Data Source Connection drop-down list.

7. Click Browse to search for the name of the connection pool this block will use.
   
8. 

Fig (2): Initialization block SQL

8. In the Initialization String area, type the SQL statement that will be issued at authentication time

Create a USER System session variable, Right click on white space in the right pane

8. 

Fig (3) : Creating a System Session variable

Assign the USER session variable to Authentication Initialization block

Fig (4) : Variable USER to Authentication Initialization block