Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

generation of security reports

What is the best way to create a report with security / privilege data stored in CMS?

Thanks,

Rick P.

Former Member
Former Member replied

John,

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,

good luck

Amr

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.

Thanks.

Srinivas

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question