Could someone explain the following:

Ran the oracle script utlpwdmg.sql that creates the default verification function for oracle 8i. The users that were currently logged into the test system received several errors indicating record locks. They also received these messages upon attempting to log back into the system. Why did the running of this script effect the users in this manner?

Thanks in advance
-Tim

Go out to Oracle's MetaLink online support repository and see what Oracle has listed on the ramifications of running that script. I found several hits out there, but could not zero in on a specific reason because you did not list the error messages you were getting. MetaLink access is free to Oracle customers who have support contracts. Just go to http://metalink.oracle.com/ and register for a userid if you haven't already.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Thanks for referring to metalink....

Let me present you with this:
We have one oracle user and all baan users are connect to this oracle db user. versus an oracle user for each baan user..
We didn't have any password history/ expiration or complexity to this oracle user. This script will allow it with some modifications.

Do you have a similar setup? How, or even, do you expire the oracle user password?

Our Baan userid's each have their own Oracle userid and password. The Oracle ID is created at the same time that Baan and UNIX ID's are created. The user only knows their Baan ID and password and never their Oracle ID or it's password. The Oracle permissions are passed to each Baan / Oracle user through an Oracle role. We change the Baan passwords every 6 months, but because the Oracle password is encripted in Baan, and they don't know what it is, we don't bother with changing or expiring the Oracle password.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Hi, I have a question about the BAAN users not know their Oracle passwords and SOX compliance. First just to let you know, I am an Oracle DBA supporting a BAAN user group and I have very little BAAN application knowledge, but we as well have one oracle user per BAAN user and now with SOX I have been requested to expire the oracle passwords every 90 days. My question is if I expire the oracle passwords how do I update the BAAN application so the BAAN users do not notice the change? Is there a BAAN tool that will handle this? I would like to create a script that will allow me to change the BAAN users Oracle password and then update whatever file BAAN uses to store the Oracle password so the BAAN user does not need to know the Oracle password. Has anyone created a script like this or know of another solution that might have the same affect? Any responses would be appreciated.

Thanks,
Daryl Salter

Use the following session and set a default password or reset the password to a new one.

Convert SSA ERP User to Database User (ttdba0915m000)
Use this session to convert a group of SSA ERP users) to database users for a selected RDBMS. The link between the SSA ERP user and database user is created during this process. The SSA ERP user must be linked to a database user to use information from the database.
To convert SSA ERP users to database users complete the following procedure:
Select a database.
Select a range of SSA ERP users.
Select the database group.
Select the checkbox to display errors which occur during the conversion process.
Choose the Convert command to start the process.