Restricting modifying the Sales Order

Hi Expert,

Hope you can help on this...

I have to restrict specific user to modify the Sales Order where Series='SO-BOM', they can only modify this Sales Order with authorization from manager or from specific user....

Can i do this on TransactionNotification from StoredProcedure?

Thanks,

Richard