How to replace alias table

[Former Member]

Hi,

  In Information Design Tool, we can create data security profile such that we can replace DB tables for each user. But how can we handle/replace those alias tables?

[Former Member]

Hi Victor,

You can go to Tables tab of the data security profile and provide the replacement table, but why is that would want to replace an alias table.

As far as i know you can replace base tables using this option. what is the reason requirement that is forcing you to apply this security on an alias table?, so that someone can suggest alternatives if any

Thanks

Mallik

[Former Member]

Thanks Mallik,

   Since we got a user who can only see the DB tables in another schema, we need to replace the alias tables too. Otherwise, the user cannot retrieve the SQL properly since he has no right to access the original schema.

  So, we really want to know if there is any way to replace alias table properly in Information Design Tool, or if there is any workaround? Many thanks in advance.

Victor

[Former Member]

Hi Victor,

below are the alternates that I can think of, which could be useful to handle your scenario.

- replacing the alias table with derived table as DT is treated same as base tables and can be replaced and user would have access to it.

- Replacing the individual objects from alias table with alternate objects from base table, but this creates duplicate set of objects in universe for those who have access to everything.

Hope this helps...

Thanks

Mallik

[Former Member]

Hi Victor,

Were you able to achieve this with any of the alternatives? please update here if you have got any solution/work around for this.

Thanks

Mallik