Collections:
"ALTER AUTHORIZATION" - Changing the Ownership of a Schema in SQL Server
How To Change the Ownership of a Schema in SQL Server?
✍: FYIcenter.com
If you want to change the owner of a schema, you can use the "ALTER AUTHORIZATION" statement using the following syntax:
ALTER AUTHORIZATION ON SCHEMA::schema_name TO user_name
The following tutorial example shows you how to change ownership of schema "fyi" to "fyi_user":
-- Login with "sa" USE FyiCenterData; GO ALTER AUTHORIZATION ON SCHEMA::fyi TO fyi_user GO SELECT s.name, u.name AS owner FROM sys.schemas s, sys.database_principals u WHERE s.principal_id = u.principal_id; GO name owner ------------------- -------------------- dbo dbo fyi Fyi_User guest guest ...
2016-10-22, 783👍, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...