ramondea
ramondea

Reputation: 317

Difference between owner and schema in the database

Which the owner of difference in a database schema? Listen in technical meetings the database staff use the word onwer.

Upvotes: 0

Views: 879

Answers (1)

Juan Carlos Oropeza
Juan Carlos Oropeza

Reputation: 48197

Owner is related to permisions over database objects. https://technet.microsoft.com/en-us/library/aa905208(v=sql.80).aspx

Schema is just a way to organize your object inside the db, think like folder for your files.

http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server

Upvotes: 1

Related Questions