topic Re: rsau/SQL-Audit/filename? in Application Development and Automation Discussions

rsau/SQL-Audit/filename?

Former Member — Fri, 02 Mar 2007 06:28:33 GMT

Hi all,

I just activate the security audit function in SAP system by using SM19. I can find the audit log file xxxx.aud in the location specified in the Static Profile. However I can not find SQL_++++++++.AUD in the location specified by rsau/SQL-Audit/logdir parameter. Why is that??? my Database server is MS SQL 7.0

Thanks

Alvin

Re: rsau/SQL-Audit/filename?

desiree_matas — Fri, 02 Mar 2007 15:57:40 GMT

Hi Alvin

What is the value for rsau/SQL-Audit/switch? Is there any AV1 message in your system log regarding security audit?

Regards,

Désiré

Re: rsau/SQL-Audit/filename?

Former Member — Mon, 05 Mar 2007 02:08:18 GMT

Hi Désirée

thanks for reply me.

I have been stupid to overlook the parameter rsau/SQL-Audit/switch. its value is OFF. I think this is reason why I can not find the SQL_++++++++.AUD file.

Thanks for remind me.

Alvin

Re: rsau/SQL-Audit/filename?

desiree_matas — Mon, 05 Mar 2007 08:47:25 GMT

Hi Alvin

Let us know if that was the reason

Regards,

Désiré

Re: rsau/SQL-Audit/filename?

Former Member — Thu, 08 Mar 2007 01:21:07 GMT

Hi Désirée

Sorry, we are not going to activate the SQL audit at the moment, but I guess the value of rsau/SQL-Audit/switch is most likely the reason why I can not the SQL_++++++++.AUD file.

Regard

Alvin

Re: rsau/SQL-Audit/filename?

Former Member — Fri, 09 Mar 2007 10:35:35 GMT

Yes that's the reason why you don't see any SQL+++++.AUD files. Thoose files are not created until you activate the rsau/SQL-Audit/switch.

We have activated it an up until the switch was activated we didn't have any files and afterwards (and of course telling the system which tables to log) we did get the files.

Keep in mind this is going to degrade your system performance, we haven't noticed any major degree in performance but I guess when we put some more load on the system we will notice.

/Mathias