Hi,

within session ttdba0515m000 (Database Users) I can doubleclick a user. I will get session ttdba0115m000 (Database Users details).
With this session it is possible to change the password for this database user. This is done on a per user basis.

Is there also a possibility to change the password for a range of database users?

Regards,

Wim Ensing

Hi Wim,

You might need to do some scripting to do that.

Here is more info for the options -



$ cd $BSE/bin
>ora8_maint6.2 -U [check your version]

Usage:

Add an user.
[ -n ] -a Baan User -m DBMS User -p User Password -G group { -F -c DBMS Admin -i
DBMS Admin Password | -P Group Password }

Change user password.
[ -n ] -r Baan User -m DBMS User -p New Password -G group { -o Current Password
| -F -c DBMS Admin -i DBMS Admin Password }

Drop an user.
[ -n ] -d Baan/DBMS User -G Group { -F -c DBMS Admin -i DBMS Admin Password | -P
Group Password }

Add a group.
[ -n ] -A group -P Group Password { -F -c DBMS Admin -i DBMS Admin Password }

Change group password.
[ -n ] -R group -P Group Password { -F -c DBMS Admin -i DBMS Admin Password | -o
Current Group Password }

Drop a group.
[ -n ] -D group { -P Group password | -F -c DBMS Admin -i DBMS Admin Password }

Check password: -h -m DBMS user -p password -G group

Batch mode: -b batchFile

Redirect errors to errorFile: -q errorFile

Set environment variables: -O environmentList

Print Usage. -U

Print Version Information. -v or -V

OK. I managed to create a script to change the password from the commandline. But the user cannot start a Bshell since ora_users is not updated.

On UNIX I can use encrypt6.2 to create an encrypted password and place this in the table ttdba010 for company 000 and update the ora_users file.

How can I encrypt the password and perform the same 2 steps on a Windows machine?

Wim Ensing