IQ DB Auditing

[Former Member]

Hi All,

I did some readings  on IQ auditing  , I followed below steps :

1.	SET OPTION PUBLIC.AUDITING = 'ON'
2.	sa_enable_auditing_type('DDL')
3.	dbtran -g mydb.log mydb.sql

I am able to view the  Audit details in mydb.sql  But all the time I need to run the step 3 ,  is this  a  right approach for Sybase IQ auding , Or is there any log file  when I can get details   like we have for HANA .

Thanks,

Razal

[Former Member]

Hi Mohamed

please have a look to the -zr option (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00168.1601/doc/html/saiq-...)

Also -zn, -zs, -zo.

Dan

[former_member755915]

Hi,

We have enabled auditing in our environment, but customer needs the sql text along with the time stamp. we tried below command after shutting down the db server, but we got audit info of only DBA user. How to get the info of all the users?

dbtran -g transaction-log SQL-file