Has anybody encrypted a specific field inside IFS? Such as SSN for employees? Does it have to use the encryption in Oracle?
Thanks.
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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.