June 6, 2011 at 2:25 pm
Hi,
We are encrypting user identifiers in our database for a client.
For example UserFirstName, UserLastName, UserEmail, UserPhoneNum etc
And also we are generating unique system id for each user (User1, User2,…)
All user identifiers are encrypted.
Now our client is aksing for unique identifier and user FN,LN details for each user. So that they can use this same identifier in their system so that they are all
linked.
Lets say I have decrypted user details (User1, FN,LN ),
if they wish to index with another systems or systems, is to simply use patient name and patient email?
Thank you.
June 6, 2011 at 2:38 pm
What is the question here?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 6, 2011 at 2:58 pm
Is it fair to provide the unique identifier (generated by our system).
Just wondering how they sync username with unique identifier in their system
any suggestions for best practice. THanks
June 6, 2011 at 3:02 pm
laddu4700 (6/6/2011)
Is it fair to provide the unique identifier (generated by our system).Just wondering how they sync username with unique identifier in their system
any suggestions for best practice. THanks
I seriously doubt that if you planning on providing a way for somebody else to look up some matching data on their system that a value unique to you is going to help them at all. That is like saying can find my medical information, the ID on Sean's system is 3FD7C363-BB26-4F4D-8776-CBA50DC4FE94
If you are trying to coordinate with external systems you will have to negotiate with the other party about what will work for both of you.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply