How to call dbms_crypto package from Oracle BI publisher
We have a requirement to call dbms_crypto.encrypt package from BI publisher to encrypt sensitive data at the column level.
So i have 2 questions:
- When we select Data Source as ApplicationDB_HCM which schema/user is it using? (eg apps, fusion etc.)
- If we raise SR on Oracle to grant execute on dbms_crypto to that user will Oracle allow it.
thanks,
Gyanesh Purohit
Tagged:
0