Is it possible to make a custom message when prompting for a password to open a protected pdf?
"Please enter the last four digits of your SSN" instead of just "enter the password"?
Not if you use the built-in security policy, no. It can be done using a
script, but that's much less secure, of course.
Retrieving data ...