Generate structured user/role/permission reports

[Walter.Koller]

Hi,

I need to generate reports to easily provide the information what user have what roles and which permissions.

The easiest to read would be probably a table with rows as roles and users as columns and a X to mark the spot who has what.
Then a similar report with rows showing permissions and columns show the roles.
Or rows as columns and columns as rows, this will not make a big difference.

I generated one of the built in reports (v6.4) but this is just (at best semi-structured) list and has to prepared first to do anything with the data. (btw is there a way to defined my own reports to be generated?).

I tried to query the DB but for some reasons the joins between BPAUsers, BPAUserRoles, ... don't return any results.

Any hints are much apprecieated,
Thanks

------------------------------
Walter Koller
Solution Manager
Erste Group IT International GmbH
Europe/Vienna
------------------------------

[Walter.Koller]

Ah I know this feature but I cannot use it via double click but I have to open the menu. This already worked in 6.4
The provided information would be the same as in User Roles I assume? But in User screen it shows much more since there are all roles for all users with yes/no flag.
I did the mistake (again :(( ) to click on the 'Click to show groups' link and I am waiting for about half an hour for some results, and still waiting.


------------------------------
Walter Koller
Solution Manager
Erste Group IT International GmbH
Europe/Vienna
------------------------------