I think you're referring to this sp:

USE master;
GO

SET ANSI_NULLS ON;
GO

SET QUOTED_IDENTIFIER ON;
GO

CREATE PROCEDURE [dbo].[Search] @Search VARCHAR(255)
AS

Create the login on primary db first. And then, give it the permissions you want. After that, get the SID of the login by using this code:

select sid from sys.syslogins

where...