Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ROLE PW Encryption

Re: ROLE PW Encryption

From: Nicolas Bronke <N.Bronke_at_web.de>
Date: Tue, 2 Aug 2005 22:07:01 +0200
Message-ID: <3la23aF11579iU1@individual.net>

> please post your DB version

Sorry I forgot. Normally 9.2 but I have to also support still 8.1.7

>
> you may be able to take advantage of procedure-authenticated roles. ie:
>
> create role oe_admin
> identified using oe_admin_validate;
>
> where 'oe_admin_validate' is a procedure that the user/application invokes
> to authenticate and enable the role
>

Hm, I only saw that for creating users. But I will search for it.

Regards
Nicolas Received on Tue Aug 02 2005 - 15:07:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US