I don't know if this is a well-known problem or a problem without a solution, but here goes...
I would like to take on an admin staff member who will work remotely.
As part of their job I will want them to login to the interfaces of my web-based clients (eg. Valueclick Media, CJ, Linkshare) and copy the data on sales and revenue to an .xls spreadsheet.
Now... here's the tricky bit:
Ideally I want them to be able to have access to my account on these interfaces (which obviously requires the password) but without revealing the password to them (in much the same way as auto-fill on a browser will fill in the correct password to a given site but without revealing the password explicitly)
Is the answer:
a) Don't be ridiculous, ronin, of course you have to let your remote admin staff know the passwords. You clearly have some trust issues to work on.
b) I can't believe you're even asking this dumb question, ronin - simply copy this file [INSERT FILEPATH] from your browser (which has all the autofill details already) and send it by encrypted email (or somesuch) to your remote admin staff member, ask them to decrypt it, add it to their browser and then their browser will commence auto-filling.
Okay, not bad, but how would I then de-activate the auto-fill on their browser, if I wished to?
c) There is some third-party web-based software which can handle this delicate matter securely - I'll sticky you with the details.
Excellent, please do.
d) You want to get a remote staff member to do this? Don't you realise there are macros which allow your machine to automatically download the data from the networks and update your spreadsheets, while you sleep?
Awesome! That would be the best of all possible solutions.
Basically, at the end of the day, if I set this up as a staff admin task, I want to be confident that if I then transfer this admin task from one member of staff to another in future, I don't then have to manually change fifty-odd passwords to ensure that access remains available only to one staff member and myself.
Any help much appreciated! Many thanks in advance.