Log in to AnswerLog in to Follow
UserImage.jpg
KL Yeo
31Views
3Comments
How to link and use existing SQL Server user credential table in Web Interactive App?
Question
Authentication
Logic

Hello, I would like to ask how can I create a login screen using the existing userID & password in my SQL Server?

What I have done is creating an extension to connect to my SQL Server. I saw there is a default login screen under UI Flows/Common/Login. When I double click on the "Login" button, it directs me to the Login client action. 

May I know where can I import my extension entity to check for the user login details?

Appreciate if anyone can help.

0
0
11 Apr 2022

OutSystems default login method validate the user against OutSystems User table. If you want to authenticate against external db table then you need to copy the external user data into OutSystems User table by some logic.

Like first check user in external table, if exists there but not in OutSystems User table then create one user in OutSystems User table. Until user is not in Users table will not be able to login into OutSystems applications.

0
0
11 Apr 2022

I have imported my table by connecting via Extension. May I know how to link the checking of password and userID when user clicks on the login button in login page?

0
0
11 Apr 2022

Below is the screenshot of OutSystems login client method. Before DoLogin method, you can call other server action and in that server action you will check that if user exists in external DB or not.

 

0
0
11 Apr 2022
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.