Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

rsau/SQL-Audit/filename?

Former Member
0 Likes
1,116

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

1 ACCEPTED SOLUTION
Read only

desiree_matas
Product and Topic Expert
Product and Topic Expert
0 Likes
878

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é

5 REPLIES 5
Read only

desiree_matas
Product and Topic Expert
Product and Topic Expert
0 Likes
879

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é

Read only

0 Likes
878

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

Read only

desiree_matas
Product and Topic Expert
Product and Topic Expert
0 Likes
878

Hi Alvin

Let us know if that was the reason

Regards,

Désiré

Read only

0 Likes
878

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

Read only

Former Member
0 Likes
878

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