更改數據庫中表的所屬用戶的兩個方法_MySQL

來源：懂視網責編：小采時間：2020-11-09 17:16:10

更改數據庫中表的所屬用戶的兩個方法_MySQL

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

推薦度：

點擊下載本文 文檔為doc格式

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

--更改某個表
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

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