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,
Thilina Jayasinghe
+7djay wrote:
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,
Hi, may I know how to get this get_restricted_data function? I am now trying to get data such as insurance id but result seems be masked or empty
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.