SQL integration - Preliminary tasks

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 SQL integration - Scripts for tables and views). Note, Ubisecure SSO uses views to fetch the needed information from the tables.

Please see SQL integration - Authorization 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.