cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle audit user script

By Anonymous
Not applicable

The Oracle audit script in this KB - 

https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Script-to-create-an-Oracle-user-with-the-access-required-for/ta-p/1758

still references these EBS tables - 

APPS.AP_INVOICES_ALL
APPS.RA_CUSTOMER_TRX_ALL                 
APPS.RA_CUSTOMER_TRX_LINES_ALL

The queries that Flexera uses to read these invoice tables can potentially take a long time to finish. From what I can tell the data that they collect are written to dbo.ServiceProviderApplicationUsagePerMonth in the IM database, however it doesn't appear that the compliance import even scans this table during the compliance import. Is it OK if we remove these entries from the audit user script? 

(1) Reply

Peter:

I am not sure of the impact of removing access to these tables in the create User audit script.  If the current FlexNet Agent DB scan is selecting from these tables and the audit user does not have access, then it is possible that the agent scan will fail and no Oracle DB inventory would be collected.