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, 1599🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...