Steve Jones - SSC Editor
December 6, 2019 at 12:00 am
Comments posted to this topic are about the item The Schema Name
Stewart "Arturius" Campbell
December 6, 2019 at 7:26 am
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”
December 6, 2019 at 2:52 pm
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.
-------------------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
December 6, 2019 at 7:20 pm
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.
December 6, 2019 at 7:30 pm
Ah, I see. Thanks again, Steve!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply