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.