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 ??
??? ???