Preliminary tasks for SQL integration - SSO
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.