Simulate SQL errors

You can generate errors to simulate SQL errors, as the following figure shows. If the user is pault, then the SPL routine acts as if that user has no update privileges, even if the user really does have that privilege.

Figure 1. Simulate SQL errors.

BEGIN
  IF user = 'pault' THEN
     RAISE EXCEPTION -273;  -- deny Paul update privilege
  END IF
END