Skip to Content
0

Need give permission for 2 users

Jul 30, 2017 at 06:30 AM

15

avatar image
Former Member

Hi Experts

I had SPT, i need a little modification in this

I need to allow 2 user to add & edit BP Master data, now its only able for Single (1) user

Regards

IF (@object_type = '2' AND @transaction_type IN ('A', 'U'))
BEGIN
	IF (SELECT CASE WHEN @transaction_type = 'A' AND UserSign <> 1 THEN 1
				    WHEN @transaction_type = 'U' AND UserSign2 <> 1 THEN 1
			        ELSE 0 END 
		FROM OCRD WHERE CardCode = @list_of_cols_val_tab_del) = 1
	BEGIN
		SET @error = -100
		SET @error_message = 'Only user 1 is able to create and edit business partners'
	END
END
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers