application role
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: application role

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    application role

    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Both from the manuals.....

    Example of Secure Application Role

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

    DBA_PROCEDURES
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width