application role

[ser]

hi

while creating an application role i need to pass a package name
eg.
create role myrole identified using package1

what statements should i write in this package .

i also want to view all the procedures and packages in my database how would i pass a query.

thanks

[jovery]

Both from the manuals.....

Example of Secure Application Role

http://download-west.oracle.com/docs...01.htm#1008607

DBA_PROCEDURES