Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ROLE PW Encryption
> 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