generation of security reports
What is the best way to create a report with security / privilege data stored in CMS?
Srinivas Ganapathi replied
My question was initially to Amr from BO/SAP, who quoted the following:
if you have the access to the CMS database and you know the structure of the database, you can easly create those reports,
or another way, to create it from the Audit database,
My point was that BO does not encourage users to query the CMS DB directly. Besides, one can't really query the CMS DB if one doesn't know what it contains. Thus, my question to Amr was whether BO had any documentation on the structure of the CMS database, how one can use it to retrieve meaningful information.
I used the SI_NAME field as an example. i.e. one can obtain the SI_NAME only from QB and not from the CMS DB.