11/10/2017

Useful queries for getting "signature option" grant values

select * from APPLICATIONAUTH where groupname = 'MAXEVERYONE' and app = 'WOTRACK' and optionname in ('PUBLICREPT','CREATEREPT','RUNREPORTS');
select * from SIGOPTION where optionname in ('PUBLICREPT','CREATEREPT','RUNREPORTS') and app = 'WOTRACK' order by app, optionname;

No comments:

Post a Comment