The Schema Name

Question

The Schema Name

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
December 6, 2019 at 12:00 am

#3695990

Comments posted to this topic are about the item The Schema Name

Viewing 5 posts - 1 through 4 (of 4 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72629 More actions · Answer 1

Nice question to end the week on, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

webrunner SSC-Dedicated Points: 31869 More actions · Answer 2

Thanks, Steve, great question!

I have a noob question in response to this QotD: Why is it that dbo is a schema and a db user, but there is no login called 'dbo'?

Thanks for any help.

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Steve Jones - SSC Editor SSC Guru Points: 736291 More actions · Answer 3

dbo is historical as the database owner. This morphed to a db_owner role so you don't have to map logins to dbo.

The equivalent of dbo (database owner) at the login level is instance owner. This is "sa", which maps to dbo in every database.

webrunner SSC-Dedicated Points: 31869 More actions · Answer 4

Ah, I see. Thanks again, Steve!

-- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html