Database Ownership - Does it Matter ?

Question

Database Ownership - Does it Matter ?

homebrew01

SSC Guru

Points: 55548
More actions
March 15, 2024 at 5:30 pm

#4396058

From a practical standpoint, does it matter who is shown as the owner of a database ? What if it's a network user, and their account is deleted when they leave the company?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ratbak Ten Centuries Points: 1358 More actions · Answer 1

https://dba.stackexchange.com/questions/134665/the-database-owner-account-has-been-deleted-what-impact

"I tried to create a stored procedure on a database that would execute as owner (blindly believing it to be 'sa'). The create failed because the owner didn't exist, so I had no choice but to make an ad-hoc change as the client needed the stored procedure creating."

https://learn.microsoft.com/en-us/answers/questions/135015/domain-user-that-not-exist-as-db-owner

"There are some functions in SQL like CLR Assembly loading that will fail to work if the owner is not there. Anything in the database on startup dealing with Security will fail if the DB Owner user is no longer valid or missing."

ScottPletcher SSC Guru Points: 101096 More actions · Answer 2

Agreed. You really want to have all the dbs having the same owner.

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

We create a sqluser "NonSA" to serve as dbowner for all user databases (unless other is actually needed - eg during install/upgrade of some software)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

Johan Bijnens wrote:

We create a sqluser "NonSA" to serve as dbowner for all user databases (unless other is actually needed - eg during install/upgrade of some software)

Thumbs up on that. That login is also disabled, correct?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)