Oracle 9i - Create Role Identified By Package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 9i - Create Role Identified By Package

  1. #1
    Join Date
    Mar 2002
    Posts
    200

    Oracle 9i - Create Role Identified By Package

    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.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    200
    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.

  4. #4
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  5. #5
    Join Date
    Mar 2002
    Posts
    200
    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..

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