I have a stored procedure that has an insert to a table I want to be
excluded for a particular user. Partly because they do not have
permissions to access that table at all. Also that the insert should
take place for every user but the one.

Now I have tried both in the stored procedure

IF(USER<>'MYUSER') THEN
INSERT ...

IF(USER!='MYUSER') THEN
INSERT ...

But every time the stored procedure is run by MYUSER I get an
insert/write table permission exception. Pretty sure one or the other
should work? It's driving me crazy.

Comments, thoughts, advice is all greatly appreciated.

--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
http://www.obsidian-studios.com