How can I capture all SQL sent to DB via DOA?

[giga]

I need capture and parse all SQL used in application - I need know all used tables (read/write) for setting dbrights.
Can you tell me the right way?

 

[Marco Kalter]

To capture all SQL you can use the Global LogActivity hook, which was added in 4.0.7 to allow logging and timing of all database activities (see LogActivity.doc). Parsing these SQL statements to determine the necessary object privileges requires some custom SQL analysis though.