Can we trace Cognos Self service (Query Studio) that which user is accessing which tables in database. Cognos log table only showing only one package name against all entries. Can we segregate package name?
I just responded to your post about COGIPF_NATIVEQUERY. You can join this table to COGIPF_USERLOGON on COGIPF_SESSIONID to find out which use executed which query.
There's no out of the box functionality for a list of tables.
I'm trying the same thing but problem is that native query table is not populating even checks are implemented
I just answered your other thread about data not populating.