Posts Tagged ‘Ownership’

How to change the database owner in SQL Server

Who creates the database is the owner of the database. We can change the owner of the database using either sp_changedbowner or ALTER AUTHORIZATION. When we create a database, a row created in sys.databases.It stores information like database owner, creation date, size.. We can find out the database owner name either by using T-SQL query […]

How to change database ownership in Sybase

SAP ASE database ownership can changed using sp_changedbowner system stored procedure. Syntax: sp_changedbowner loginame [, true ] Example: 1> use k2admin 2>go 1> sp_changedbowner admin 2> go Conditions to change the Database owership:

Powered by k2schools