Preliminary tasks for SQL integration - SSO
- John Jellema
Owned by John Jellema
2023-05-05
1 min read
Loading data...
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.