如何修改数据库表或存储过程的所有者

use dbname

sp_changedbowner 'new_user'

更改当前数据库的所有者。

--批量修改数据库对象的所有者

新建一个存储过程：changename

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[changename]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[changename]

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

Create PROCEDURE dbo.changename

@OldOwner as NVARCHAR(128),--参数原所有者

@NewOwner as NVARCHAR(128)--参数新所有者

AS

DECLARE @Name as NVARCHAR(128)

DECLARE @Owner as NVARCHAR(128)

DECLARE @OwnerName as NVARCHAR(128)

DECLARE curObject CURSOR FOR

select 'Name' = name,

'Owner' = user_name(uid)

from sysobjects

where user_name(uid)=@OldOwner

order by name

OPEN curObject

FETCH NEXT FROM curObject INTO @Name, @Owner