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?
views:
80answers:
1
+1
A:
It appears that AUTHORIZATION confers ownership of a database-contained entity.
Jim G.
2009-09-29 15:25:14
That si correct, but is not restricted to database-contained entities alone, since the database itself can be changed ownership (`ALTER AUTHORIZATION ON DATABASE:<dbname>` which is the same as `sp_changedbowner`). Also endpoints can be changed authorization (ownership), but are instance level entities.
Remus Rusanu
2009-09-30 00:32:07