Sorry for the swedish words. Just did not notice it!
I've written a privilege report (in isolation to the report previously written)... It's not complete! I'll be posting a completed report as soon as I have the time to think.
In order that this report can be run a database view is required.
This report has two views 'console' and 'overview'.
Overview = will list all of the actions and the privileges that each group/role has against that action.
Console = a list of all privileges based on the role or group you specify.
Create view gnr
(select tps_name, tps_title, tps_guid, tps_privilege_collection_guid, 'role' as source from tps_role
select tps_name, tps_title, tps_guid, tps_privilege_collection_guid, 'group' as source from tps_group)
report is not showing the correct privileges where actions related to a object exist.
Mirror exactly what is seen in the console. Lifecycle branch is missing.
Result of Privilege.rpt 16.0 K
Does anyone know if there has been made progress on this?
We'd like to create an overview of all roles/privileges but doing this by hand (and maintaining it) seems a bit hard...