USE [IHBoxSystem]
GO
CREATE ROLE lad_meltorders_read AUTHORIZATION dbo 
GO  
USE [IHBoxSystem]
GO
EXEC sp_addrolemember 'lad_meltorders_read', 'SDI/australtek'
GO
USE [IHBoxSystem]
GO
EXEC sp_addrolemember 'lad_meltorders_read', 'admin'
GO



INSERT INTO [SECURITY].[ModuleActions]
		   ([ModuleId]
		   ,[Code]
		   ,[Name]
		   ,[Role])
	 VALUES
		   (80
		   ,'readWrite'
		   ,'Read/Write'
		   ,'lad_meltorders_read')
GO



EXECUTE sys.sp_addextendedproperty 
@level0type = N'USER' -- The object type
,@level0name = [lad_meltorders_read] -- The role
,@name = N'securedsp-LAD.GetMeltOrders' -- the procedure
,@value = N'' 
GO

EXECUTE sys.sp_addextendedproperty 
@level0type = N'USER' -- The object type
,@level0name = [lad_meltorders_read] -- The role
,@name = N'securedsp-LAD.GetMeltOrderDetails' -- the procedure
,@value = N'' 
GO