Skip to main content

Has anybody encrypted a specific field inside IFS? Such as SSN for employees?  Does it have to use the encryption in Oracle? 

 

Thanks.

Didn’t encrypt. In the view level we can call custom method and return the actual value for specific users by checking permission set and for others any hard coded value like ‘XXXXXXXX’. There we have the requirement only not to show it for all users.

 

SELECT person_id                      person_id,
              --Pers_Api.Get_insurance_id(person_id) insurance_id,
             <cust_pkg_api>.Get_Restricted_SSN(person_id,Pers_Api.Get_insurance_id(person_id)) insurance_id,


Reply