更改數(shù)據(jù)庫中表的所屬用戶的兩個(gè)方法_MySQL

來源：懂視網(wǎng) 責(zé)編：小采時(shí)間：2020-11-09 17:16:10

更改數(shù)據(jù)庫中表的所屬用戶的兩個(gè)方法_MySQL

更改數(shù)據(jù)庫中表的所屬用戶的兩個(gè)方法_MySQL:--更改某個(gè)表exec sp_changeobjectowner 'tablename','dbo' --存儲更改全部表CREATE PROCEDURE dbo.User_ChangeObjectOwnerBatch @OldOwner as NVARCHAR(128), @NewOwner as NVARCHAR(128)AS DECLARE

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

導(dǎo)讀更改數(shù)據(jù)庫中表的所屬用戶的兩個(gè)方法_MySQL:--更改某個(gè)表exec sp_changeobjectowner 'tablename','dbo' --存儲更改全部表CREATE PROCEDURE dbo.User_ChangeObjectOwnerBatch @OldOwner as NVARCHAR(128), @NewOwner as NVARCHAR(128)AS DECLARE

--更改某個(gè)表
exec sp_changeobjectowner 'tablename','dbo'

--存儲更改全部表
CREATE PROCEDURE dbo.User_ChangeObjectOwnerBatch
@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
WHILE(@@FETCH_STATUS=0)
BEGIN
if @Owner=@OldOwner
begin
set @OwnerName = @OldOwner '.' rtrim(@Name)
exec sp_changeobjectowner @OwnerName, @NewOwner
end
-- select @name,@NewOwner,@OldOwner

FETCH NEXT FROM curObject INTO @Name, @Owner
END

close curObject
deallocate curObject

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com