Preliminary tasks for SQL integration - SSO

Owned by John Jellema
2023-05-05

SQL database tables or views

Before the SQL database can be used as an external directory it should contain Ubisecure specific tables and views:

Views

Tables

UbiloginAccountStatus

Attributes

UbiloginAttributes

History

UbiloginAuthorizer

Terms

UbiloginPassword

Users

UbiloginPasswordHistory

 

UbiloginTerms

 

These views and tables can be created using sql scripts provided by Ubisecure (See Scripts for tables and views in SQL integration - SSO). Note, Ubisecure SSO uses views to fetch the needed information from the tables.

Please see Authorization in SQL integration - SSO how to configure the Authorization Policy in Ubisecure SSO.

Also, more information on the Ubisecure database tables can be found from the SQL Accounts document.

Ubisecure Privacy Policy & Cookie Statement