App to show apps user has

[roedea]

I keep getting asked by our Compliance department which apps so-and-so has authority to. How can I make an app that they can run and search up a user or group and see what apps that user or group has access to?

[sean.lanktree]

We are looking at adding something for this in 6.4.
If you cannot wait, it should be a pretty simple application to create in NAB. Here is the sql to pull the info:

SELECT
  DISTINCT a.vvappname AS appname
FROM
  vvusers AS u
  JOIN vvusrauth AS au ON u.vvusrid = au.vvusrid AND au.vvautmode = 'E' AND au.vvobjtype = 'G'
  JOIN vvappgrps AS ag ON ag.vvgrpid = au.vvobjid
  JOIN vvapps AS a ON ag.vvappid = a.vvappid
WHERE
  u.vvusrid = SOME_USER_ID
?