is there a better way to review who has permissions to modules? (VE 6.5.4)

Occasionally, i need to review who has permissions to a specific module and I'm trying to use the tools available within the application (VE 6.5.4).

Is there a better method than reviewing the "Print Security Report" by Module ID? The report is currently over 4000 pages and takes very long time to run. Luckily I'm able to save it to a PDF for my review.

Any suggestions?

Find more posts tagged with

Comments

Legacy Contributor

I would also like to know this.

Legacy Contributor

Years ago there was a MS Access program created that we use. You will need to change linked table ODBC settings to match your database. I'm attaching the file

Legacy Contributor

I wrote a t-sql query to do this. It doesn't work in Visual's Query Tool, you'll need to run it in SSMS or a different reporting tool.

declare @app varchar(10) = 'VMAPLGLB';

select au.NAME, MIN(case when PERMISSION is null then 'Y' else PERMISSION end) as 'PERMISSION' from APPLICATION_USER au
left join USER_PROFILE up on up.[USER_ID] = au.NAME
left join USER_PGM_AUTHORITY upa on upa.[USER_ID] = up.PROFILE_ID and PROGRAM_ID = @app
where au.IS_PROFILE is null
group by au.NAME;

Legacy Contributor

This is easy if you have Synoptix or a report-writer like it. Just do a view/sphere that uses the USER_PGM_AUTHORITY table (which only has six fields) and you'll have what you need. Then sort by PROGRAM_ID OR USER_ID, whatever you need to look at.

Disaster Recovery Planning.pdf

Copyright © 2025 Infor. All rights reserved.