I learnt that in Oracle 9i there is a feature to create a Role identified by a Package, to avoid hard-coding of the Password in applications. We never indicate the Password of a Role anywhere in the application? Can anyone explain how this feature might be useful?

Many thanks in advance.