insert into applicationauth (app, optionname, groupname, applicationauthid)
select sigoption.app, sigoption.optionname, 'MAXADMIN' as groupname,
applicationauthseq.nextval as applicationauthid
from sigoption left join applicationauth
on (sigoption.app = applicationauth.app
 and sigoption.optionname = applicationauth.optionname
 and groupname = 'MAXADMIN')
where applicationauth.app is null
 and applicationauth.optionname is null
 and sigoption.optionname
 not in ('DELETEREPT', 'NOPORTLET');