Change Owner of the Tables of a BD


In MS SQL, you can change the owner of the tables in the current database.


If we want to manually establish the owner of a table (or in general of any object) of MS SQL we can resort to a script. Just open the query analyzer and write the following command:

ALTER SCHEMA dbo TRANSFER [current_owner] .tablename;


current_owner = Replace with the name of the current user owner of the table
tableare = Replace with the name of the Table
dbo = Replace with the new user of the Database

More information:

Alveni Cloud is not responsible for the loss of data and / or the mishandling of information by the user.