What's a good way to mask a consumerID?

  • Hi!

    I'm working with a database that has that stores information about consumers that are under our customers.

    So for example Customer 1234 has consumers 111,112,113, and 114 and Customer 1235 has consumers 115,116,117, and 118, and so on.

    This wasn't a problem but now our Product Owner doesn't want our customers to see how many consumers we have.

    What would be the best practice for masking these consumerIDs but still giving our an ID to our Customers?

    So we want to have Customer 1234 see their consumers as 1,2,3,4 but also have Customer 1235 see their see consumers as 1,2,3,4 or A1, A2, or whatever.

  • Just use the "ROW_NUMBER() OVER" and partition by customer.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply