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,

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


Terms & ConditionsCookie settings