Database Owner (DBO)


Definition of DBO (Database Owner) in the Network Encyclopedia.

What is DBO (Database Owner)?

Database Owner, or dbo, (in SQL Server) is the user account that created the database and is responsible for managing administrative tasks related to a SQL Server database.

Database Owner (DBO)
Database Owner (DBO)




Each SQL Server database is considered a self-contained administrative domain and is assigned a database owner (DBO) who is responsible for managing the permissions for the database and performing tasks such as backing up and restoring the database’s information.

Essentially, the DBO can do anything within the database. By default, the SA (system administrator) account is also a DBO account for any database on a computer running SQL Server. The database owner has full permissions inside a database that it owns.



Use only the SA account

To avoid the complexity of managing separate DBO accounts for each SQL Server database, you might want to perform all administration tasks – both server-wide and specific to the database – using only the SA account.

Editor

Articles posted after being checked by editors.

Recent Content

link to Working Set

Working Set

Working set is the physical memory assigned to a process by the Microsoft Windows NT and Windows 2000 operating systems. The working set consists of pages, which are sections of code and application data that have recently been used by the process.
link to HTTPS

HTTPS

HTTPS is a protocol developed by Netscape for secure transmission of Web content over the Internet. HTTPS is another name for Netscape’s implementation of the Secure Sockets Layer (SSL) protocol that functions as a subprotocol to the application layer (layer 7) protocol, Hypertext Transfer Protocol (HTTP).