-- Name:
-- sp_MSgrantconnectreplication
-- Description:
-- This procedure will grant "connect replication" to the passed in user.
-- This permission is required for NFR to be honored.
-- Parameters:
-- Returns:
-- 0 - succeeded
-- 1 - failed
-- Result:
-- None
-- Security:
create procedure sys.sp_MSgrantconnectreplication
(
@user_name sysname
)
as
begin
declare @command nvarchar(400)
select @command = N'grant connect replication to ' + quotename(@user_name)
exec(@command)
return 0
end