Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Payroll for NA / Time and Labor - PSFT (MOSC)

How to mask data in database

Jan 3, 2023 4:35AM in Payroll for NA / Time and Labor - PSFT (MOSC) 1 commentAnswered

Hi All,

We have an ask from the Business to explore the possible ways to mask the data in the database. Here are more details to the requirement:

To restrict the developers/ other users to mask the sensitive data in the database. When we query any record, few of the sensitive information like SSN, Bank acct number, Phone numbers must be masked.
Since the requirement is to mask for the developers as well, how can IT team perform the testing and validate the data provided.
What are the possible ways of masking the data?
Pros and cons of implementing this functionality.

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month