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 ...
⇒ Accessing a Schema Not Owned by You in SQL Server
⇐ Who Is the Owner of a Schema in SQL Server
2016-10-22, 1590🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...