Skip to Content
0
Former Member
Mar 12, 2015 at 11:49 AM

how to block sap b1 database using SP except Manager ID

43 Views

please help if ( (@transaction_type ='A' or @transaction_type ='U' )) begin (SELECT USERID FROM [OUSR] WHERE userid = @list_of_cols_val_tab_del and USERID=1) begin set @error = 66666 set @error_message =N'You are not authorized to make any change ' end end