Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
if
not exists (select * from sysusers where name = 'BFGROUP' and issqlrole = 1)exec
sp_addrole 'BFGROUP'GO
declare
@cStatement varchar(255)declare
G_cursor CURSOR for select 'grant select,update,insert,delete on "' + convert(varchar(64),name) + '" to BFGROUP' from sysobjects where (type = 'U' or type = 'V') and uid = 1 order by nameset
nocount onOPEN
G_cursorFETCH
NEXT FROM G_cursor INTO @cStatementWHILE
(@@FETCH_STATUS <> -1)begin
print @cStatementEXEC
(@cStatement)FETCH NEXT FROM G_cursor INTO @cStatementend
DEALLOCATE
G_cursorGO
declare
@cStatement varchar(255)declare
G_cursor CURSOR for select 'grant execute on "' + convert(varchar(64),name) + '" to BFGROUP' from sysobjects where (type = 'P') and uid = 1 order by nameset
nocount onOPEN
G_cursorFETCH
NEXT FROM G_cursor INTO @cStatementWHILE
(@@FETCH_STATUS <> -1)begin
print @cStatementEXEC
(@cStatement)FETCH NEXT FROM G_cursor INTO @cStatementend
DEALLOCATE
G_cursorGO
Keywords: kbmbsmigrate, kbmbspartner, vkball, kb