Authorization for remove Bom
Is there a way using SP Stored Procedure to stop users from removing BOM ? But just someone can remove the BOM the others can't.
I have already try SBO_SP_TransactionNotification something like this:
DECLARE @User Nvarchar(8) IF @object_type='66' BEGIN SELECT @user=T1.USER_CODE FROM OITT T0 LEFT JOIN OUSR T1 ON T0.UserSign2 = T1.USERID WHERE T0.Code=@list_of_cols_val_tab_del IF @user='manager' BEGIN IF @transaction_type='D' begin set @error=1 set @error_message=N'You can't delete the BOM' end END END
But it can't work!!! How can I do?
Thanks in advance,