Wednesday, November 1, 2017

who is Database Owner?


     Whenever a new database is created, the server wants to keep track of who created that database. This is known as the database owner. By default, Microsoft SQL Server creates a special account named dbo(for database owner). When you create a database but do not specify the owner, this account is used. The dbo account is also given rights to all types of operations that can be performed on the database. When you install Microsoft SQL Server, it also installs 4 databases named master, model, msdb, and tempdb. You should avoid directly using them, unless you know exactly what you are doing.

No comments:

Post a Comment

GEN AI

  Stay Tuned....