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, 1676🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...