SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create procedure [dbo].[p_user_product_rights]
	@user_code ais_code_medium,
	@product_code ais_code_short

as 
	select * 
	from usr_users_products
	where		usrp_user_code = @user_code
			and usrp_product_code = @product_code

	select *
	from pr_products
	where prd_product_code = @product_code
GO
