Thanks for your reply Russel. That method will definitely speed up promotion.
That said for a couple of reasons, not limited to my own curiosity, I would still like to know how to use SSO properly. First in the (very likely) event that I have to link to several Oracle databases in a single application the method you mentioned above would be fairly inconvenient as I would have to replace each password one by one. Also I may be a bit paranoid but is it a good idea to have production passwords easily visible in plain text?
Any suggestions?
Thanks
Stuart