Authorization on oracle function in Framework Manager?

[wdv72]

Hi all,

I have been searching for an option to incorporate an Oracle function, that decodes a social security number, in my framework and place AD security on it.

What I would like is authorization on the function in a way that users, that are not allowed to see the social security numbers and therefore are not allowed to use the function, don't get to see the result of the function in a report.

I prefer not to incorporate the function in multiple Query subjects/items as it would be a lot of maintenance-work.

Hope you can help.

kind regards.