Collections:
Who Is the Owner of a Schema in SQL Server
Who Is the Owner of a Schema in SQL Server?
✍: FYIcenter.com
When you create a schema in a database, SQL Server will assign a owner (a database user) to this schema. If your login name is mapped to the owner of a schema at the database level, you have the full permission on all objects in this schema.
The following tutorial exercise shows you how to see who is the owner of a schema:
-- Login with "sa" USE FyiCenterData; 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 dbo guest guest ...
The last query shows that schema "fyi" is owned by "dbo".
⇒ "ALTER AUTHORIZATION" - Changing the Ownership of a Schema in SQL Server
⇐ Default Schema of Your Login Session in SQL Server
2016-10-22, 1350🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...