Passwords in Roles

From: Michael42 <melliott42_at_yahoo.com>
Date: 19 Jan 2007 03:34:40 -0800
Message-ID: <1169206480.440576.81200@11g2000cwr.googlegroups.com>

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 Received on Fri Jan 19 2007 - 05:34:40 CST