-- 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