CODEWITHSUNDEEP
sql-server-2008permissionsauthorization
Jim G.
Jim G.

Reputation: 15363

SQL Server 2008: What does it mean to grant a user "AUTHORIZATION" over a schema?

I see the following in one of my database scripts:

CREATE SCHEMA [ContosoSchema] AUTHORIZATION [ContosoDeveloper]
GO

My question:

In SQL Server 2008, what does it mean to grant a user "AUTHORIZATION" over a schema?

Upvotes: 0

Views: 461

Answers (1)

Jim G.
Jim G.

Reputation: 15363

It appears that AUTHORIZATION confers ownership of a database-contained entity.

Upvotes: 1

Related Questions