Route users basing on Cognos Connections

[alis]

Good morning everybody! :)
I have a question about Cognos Connections and I need an answer real quick... :( can you please help me?
On a DB, I have two views of the same table MYTABLE.
I would like to associate one view to one Cognos Connection, the other one to another Cognos Connection.
Then, basing on which Cognos Connection an user (or group of users) is enabled to, show him the first one or the second one.
How can I do?

More specifically,  the case is that:
- I already have a lot of packages and table MYTABLE is present in each of them;
- Most of the other tables I already have in my packages are to be shown to everybody without restrictions;
- I need to hide the values of column A of MYTABLE to a group of user and the values of column B of MYTABLE to another group.

I would like to avoid to profile user permissions in every package I have: it would take a lot of time.
I would just like to route users basing on the Cognos Connection they are enabled to.

Can anybody help me?

Thank you in advance!! :)

[alis]

...nobody?  :'(

[adam_mc]

Can't you control this on the database side rather than in Cognos.

Define the table in the model and then direct it to use a view instead based on role.
In the view define the value of your columns you wish to secure appropriately.

Just a thought...