--- title: "Modifying the ODBC database structure as required" slug: "oas-igwin-modifying-the-odbc-database-structure-as-required-3-29" updated: 2026-02-26T15:28:43Z published: 2026-02-27T10:54:06Z canonical: "docs.onespan.com/oas-igwin-modifying-the-odbc-database-structure-as-required-3-29" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.onespan.com/llms.txt > Use this file to discover all available pages before exploring further. # Modifying the ODBC database structure as required If you are using a custom ODBC database instead of the embedded MariaDB database, you need to manually set up the database schema required for OneSpan Authentication Server. To do so, use the addschema command of the dpdbadmin utility. > OneSpan Authentication Server requires any of the following: > > - A database administrator account for the database. > - Ownership of the OneSpan tables. > - Permissions to insert, remove, read, and modify rows in OneSpan tables. > > This is set up automatically if you choose to use the embedded MariaDB database. For more information about permissions required for administration tasks, see [Administrative privileges](/sec/docs/oas-ag-administrative-privileges-3-29). > > Before you perform the following procedure, ensure that it is possible for the dbusername account to reference the tables by name without a schema prefix. If this cannot be done, see [Database user accounts](/sec/docs/oas-ag-database-user-accounts-3-29) for advanced setup instructions. To manually apply the required schema to custom ODBC databases 1. Copy dpdbadmin.exeto the computer from which the database can be accessed. You can retrieve dpdbadmin.exe from the product installation CD or the installation folder (by default %PROGRAMFILES%\VASCO\IDENTIKEY Authentication Server). 2. Create an ODBC data source for the database on the computer, if one does not currently exist. 3. Open a command prompt and navigate to the location to which dpdbadmin.exe was copied. 4. From there, run the following command: dpdbadmin addschema –u dbusername –p dbpassword -d dsn where: - dbusername is the user name of the database administrator account. - dbpassword is the corresponding password of dbusername. - dsn is the ODBC data source name. After performing an ODBC data store extension, you can use the checkschema command to check whether the schema updates have been completed (see [Verifying schema updates](/sec/docs/oas-igwin-verifying-schema-updates-3-29)). For more information about dpdbadmin addschema, see [dpdbadmin addschema](/sec/docs/oas-aref-dpdbadmin-addschema-3-29).