Database Ownership - Database Ownership - OnBase - Database Reference Guide - OnBase/Database-Reference-Guide/Foundation-23.1/Database-Reference-Guide/Installation/SQL-Server-Configuration-Recommendations/Database-Ownership - Foundation 23.1 - Foundation 23.1

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License
ft:lastPublication
2025-08-21T22:01:17.527000
ft:locale
en-US

Members of the db_owner database role can perform all configuration and maintenance activities on the database. A database's db_owner is assigned at database creation and additional users can be given the db_owner role by any user who is also a db_owner. A user with this role is required to perform these activities.

The OnBase database should be created with a database user account that will never be deleted (for example, the sa database user account), rather than an Active Directory account, to ensure perpetual access to the db_owner role's capabilities.

Note:

When upgrading from the Legacy Security model, the hsi account may already be assigned the db_owner role. When using the High Security model, the hsi account does not need to be assigned to the db_owner role. For more information on the Legacy Security model, see Legacy Security Model.