Sample Header Ad - 728x90

ip address record in sybase ASE auditing database?

1 vote
1 answer
674 views
everone. I installed the *sybsecurity* database for auditing in *sybase ase 15.5*. The installation is OK. I configured the audit commands, for example, for auditing the sa user, and other users of the database. I see that the column extrainfo for the table sysaudits_01 shows additional information. I need to add the IP address of of users who perform certain commands: for example, GRANT, INSERT, 'UPDATE, DELETE, SELECT, and CREATE`. I see that rows in login attempts include the IP address in the extrainfo column. I checked the code of the file C:\Sybase\ASE-15_0\scripts\instsecu but I can't find how to add the IP address to extrainfo to my table. How can I capture the IP address for certain actions, and record it in extrainfo?
Asked by Luis Antonio Mantilla (13 rep)
Aug 17, 2017, 10:09 PM
Last activity: Aug 17, 2017, 10:58 PM