You can check if the usage of Dynamic SQL Analytic Privileges is an option for you. With that you can define an SQL Analtytic Privilege for your calc. view. The SQL Analytic Privilege uses a stored producedure in which you can determine for your user the valid plants. The procedure returns the valid values which are used to restrict the calc. view result.
If you need more information than that what is already described in the online documentation you can search here in the community. There are already several Q&As + blogs covering that topic.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.