Oracle 9i - Create Role Identified By Package

[quester]

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.

[SANJAY_G]

The syntex is CREATE ROLE IDENTFIED USING PACKAGE.

The USING package clause lets you create an application role, which is a role that can be enabled only by applications using an authorized package.

Sanjay

[quester]

Originally posted by SANJAY_G
The syntex is CREATE ROLE IDENTFIED USING PACKAGE.

The USING package clause lets you create an application role, which is a role that can be enabled only by applications using an authorized package.

Sanjay

Didn't understand. Could you elaborate a little Sir, I am afraid whether I got the advantage of this.

[Calvin_Qiu]

See Database Security Overview for Application Developers chapter of Application Developer's Guide for more information. You would enjoy an example in Creating Secure Application Roles section.

[quester]

Originally posted by Calvin_Qiu
See Database Security Overview for Application Developers chapter of Application Developer's Guide for more information. You would enjoy an example in Creating Secure Application Roles section.

That is always there. Anyone who can explain the advantage on the board here.

Thanks..