Input Parameters of Calculation View by Procedure with Analytic Privilege

Hi I should set different input parameters of calculation view reading the values from a table in according with an "analytical privilege" for example in my table I have 2 record one for ADMIN and another one for LOCAL users with 4 columns.

If I run my calculation view using an ADMIN user (It's possible to have more than one administrator users), I should read only the record from my table for ADMIN, I thought to use privilege to filter this record dynamically but I can't use this solution because input parameters work with table but analytical privileges work with view so I can't filter my record.

Is there any other way to filter dynamically from a table in according with privilege or role?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers

Skip to Content