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

Home -> Community -> Usenet -> c.d.o.server -> Re: Passwords in Roles

Re: Passwords in Roles

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 19 Jan 2007 07:11:35 -0800
Message-ID: <1169219492.498882@bubbleator.drizzle.com>


Michael42 wrote:
> Hello,
>
> I have recently become responsible for an Oracle 9i database where a
> set of applications that were written for it extensively use passwords
> in Oracle Roles. The developer who architected these apps has since
> retired so I cannot ask him why he did this. It is causing a great
> hindrance as I prep this database from 10g (exp\imp etc.).
>
> Are there any sound reasons to store passwords in Oracle Roles in
> modern Oracle databases, what are your thoughts on this practice?
>
>
> Thanks for your feedback,
>
> Michael42

What is it, exactly, that is causing the issue. The phrase "causing problems" leaves a lot to the imagination.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jan 19 2007 - 09:11:35 CST

Original text of this message

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