COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: coghelp on 15 Jun 2010 11:10:44 AM

Title: Security question must see
Post by: coghelp on 15 Jun 2010 11:10:44 AM
If we have a data level security applied in FM, is it possible to track the data level security query in any of the Audit reports or tables (Native query)? Other question for the same data level security will that apply with in the same query what report generates or will it be handled by application server out of query? or else any thing other then this two?.

Thanks!
Title: Re: Security question must see
Post by: MFGF on 16 Jun 2010 04:10:45 AM
Hi,

When you apply data security, this is implemented in the form of filters, which are in turn included as a predicate (WHERE clause) in the normal runtime queries generated within the studios.

You can enable recording of native query logging within the audit database from within the Administration console.

Regards,

MF.