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
Last activity: Aug 17, 2017, 10:58 PM