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.