Cognos and Oracle Row Level Security ..

[NaviGator]

Hello guys,

In our environment we have Cognos 8.3 and Oracle 10g database. In the Oracle database, row level security is applied on the data based on the username. The users are defined in a specific table for security. These users may be OS users or users coming from the authentication provider LDAP and were defined in that table with specifying the user role for each user. The can be illustrated as follow,

User     Role                   Usage
-----   ------               ---------
AAA      Admin             for administrative tasks.
BBB      Power User       can see everything
CCC      User                can see only his data


Now we don't want to apply any security from Cognos side and we want to use the row level security defined in the Oracle database. When we configure Cognos to use the same LDAP and then trying to login we couldn't retrieve anything from the database. we found that Oracle is using the user defined in the data source signon and is not using the user that was using for login.

Is there any workaround for this ?

How can we archive this ?? 

??? ???