Is there a way to find out what are all the menu items a Security Group currently has access to? We are looking to add a user to a security group but need to find out if they have access to menu items that they shouldn’t be.
You can use the menu security report but it might not be a good format for you and it will most likely take a long time to run. Just filter by group and you should get what you are looking for.
For explicit access, you can query the security table like so:
select * from security
where parentseccode='menu'
and entrylist like '%security_group_id_goes_here%'
when the entrylist has an asterisk, that means all users are allowed access unless there is another restriction, like securitymgr=1 which means that only security managers are allowed access.
4 Likes