Skip to Content
0
Former Member
Apr 27, 2010 at 06:28 PM

Block users who are not marked as Super Users through SP

15 Views

Hi experts,

I am trying to block certian users (those not being Super Users) from making changes to posted Sales Orders.

So far I have a simple code that blocks all users

if @object type = '17' and @transactiontype = 'U'

Begin

Set Error = 1

Select @error_message = 'Cannot modify a posted Sales Order'

End

How would I code it so that it would only block users who are not marked as Super Users?

Thx

Richard