"unable to create/update database tables. Security Error" in Xtraction when Updating database in settings

Version 1

    [ISSUE]

    When clicking Update Database in the Xtraction settings after an upgrade: Error "Unable to create/update database tables. Security Error"

    Inability to upgrade can also lead to errors such as Error when loading Xtraction local host page: Invalid Column Name '<INSERT COLUMN NAME>'

     

     

    [INFO]

    Upgrade documentation for Xtraction can found here: Xtraction Download Archive (v2018.3 and earlier)

    There are schema changes that did not previously require the database to be db_owner

     

     

    [RESOLUTION]

     

    In SQL, give the User ID from the Xtraction database DB_Owner rights