ThierryTarrason

Extract UserGroups with Privileges and Authorizations by SQL

Discussion created by ThierryTarrason on Oct 19, 2017
Latest reply on Oct 23, 2017 by AlainMoisy
Hi,
We run AWA 11.2.5 and need to export by SQL the list of UserGroups with their privileges and authorizations for Audit reasons.
Has anyone done this before?
Seems like the info i'm looking for are in the following tables:
UACL, UC_ACLB, UC_ACLK, UC_ACLT
But i can't seem to be able to wrap my head around their bitcode fields.
Any help would be greatly appreciated.

Regards,
Thierry

Outcomes