Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th May 2003, 06:43
learner's Avatar
learner learner is offline
Guru
 
Join Date: Dec 2002
Location: New zealand
Posts: 562
learner is on a distinguished road
Baan: BaaN Vc with sp 28 - DB: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit - OS: HP-UX B.11.31
How to change BaaN Password !!!

Hi,

I would like to change the password for BaaN ( Super User ), how can i change it ?

I am running BaaN IV c4 on Win NT 4 with Informix 9 as database.

Regards

Learner
Reply With Quote
  #2  
Old 28th May 2003, 11:23
harijono harijono is offline
Junior Member
 
Join Date: Sep 2002
Posts: 10
harijono is on a distinguished road
Hi,

You can change the password of user 'baan' from NT.

harijono
Reply With Quote
  #3  
Old 28th May 2003, 11:41
MarioS's Avatar
MarioS MarioS is offline
Member
 
Join Date: Feb 2003
Location: Germany
Posts: 53
MarioS is on a distinguished road
Baan: IVc,Vc, LN - DB: Informix,Oracle, SQL - OS: Unix, Windows
Hello,

it´s not enough to change the password on operation system level, because the entry with the encrypted password in the
$BSE/lib/informix/inf_users will not be affected by that.

Using session ttdba0115m000 should be enough, however in some circumstances after running it you also have to change the password on NT.

Mario
Reply With Quote
  #4  
Old 28th May 2003, 11:43
MarioS's Avatar
MarioS MarioS is offline
Member
 
Join Date: Feb 2003
Location: Germany
Posts: 53
MarioS is on a distinguished road
Baan: IVc,Vc, LN - DB: Informix,Oracle, SQL - OS: Unix, Windows
Ups, forgot something:

If some services are running with the baan-account (e.g. job-daemon, scheduler etc.), don´t forget to adjust those services too after changing the password.
Reply With Quote
Sponsored Links
  #5  
Old 28th May 2003, 12:34
learner's Avatar
learner learner is offline
Guru
 
Join Date: Dec 2002
Location: New zealand
Posts: 562
learner is on a distinguished road
Baan: BaaN Vc with sp 28 - DB: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit - OS: HP-UX B.11.31
some more info !!

Hello,

Just to tell u something more about my current setup, right now whenever i want to add a user in baan i just create one user user using session ttaad2100m000 ( Maintain user data ) and after that i use to make an entry at o/s level and then i use to manually add a entry in inf_user file, which means that we are NOT maintaing users using sessions like ttdgba0110m000 Maintain Link between BaaN User and Database User.

so my all the users which were in inf_users file r having the encrypted password of baan since they r binded to only one database user i.e. baan

so does this means that as soon as i change my baan user password using session u told me i have to update my inf_user file also for all the users.

Am i right ?
Reply With Quote
  #6  
Old 28th May 2003, 13:54
NvanBeest's Avatar
NvanBeest NvanBeest is offline
Guru
 
Join Date: May 2003
Location: South Africa
Posts: 520
NvanBeest is on a distinguished road
Baan: BaanIVc4 - DB: Oracle, TBase, SQL Server - OS: AIX, Linux, Window$
Yes, you're right. You will have to copy the encrypted password from the baan:baan line to the other users as well. Pity you don't have access to a UNIX version of Baan. One program they forgot ( ) to port over to Windows is encrypt6.1, which allows you to create those encrypted password strings outside Baan.

Regards,
Nico
Reply With Quote
  #7  
Old 28th May 2003, 18:16
learner's Avatar
learner learner is offline
Guru
 
Join Date: Dec 2002
Location: New zealand
Posts: 562
learner is on a distinguished road
Baan: BaaN Vc with sp 28 - DB: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit - OS: HP-UX B.11.31
yep i agree with u , one more main problem is that if there is one user with the name 230rm i cannot create a database user with the same name in informix since informix doesn't allow to create a user with the name starting with a numeric, anway more probnem is that i will have to change all the users password also since i don't know their baan passwords currently.

anyway thanks for the info, it helped me a lot and cleared my doubt. r ua ware of how to create this user in informix ???

is it that i have to give the command

grant dba to rm230

is that enough ??
Reply With Quote
  #8  
Old 28th May 2003, 19:06
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,066
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Nico:
Quote:
One program they forgot ( ) to port over to Windows is encrypt6.1, which allows you to create those encrypted password strings outside Baan.
Well there is one more undocumented function to encrypt passwords in BaaN.

Code:
tgbrg160.pssw = crypt.password$("BAAN")
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
  #9  
Old 24th August 2006, 20:06
pokitlok's Avatar
pokitlok pokitlok is offline
Member
 
Join Date: Jul 2002
Location: Hong Kong
Posts: 45
pokitlok is on a distinguished road
Baan: IV - DB: Oracle, MS SQL 2000 - OS: UNIX, Windows XP, Windows 2000
Does function MSQL_MAINT help?

I just read a Baan document. It states MSQL_MAINT is to add/change the db user and group user. Anyone have try it?!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ervaren Baan specialist ICT Builder Jobs and Resumes 3 5th February 2005 06:37
Service module in Baan en@frrom Project & Services 6 12th September 2003 09:48
resetting the baan password torwin Tools Administration & Installation 1 10th September 2003 16:23
Password change thru session veyant Tools Administration & Installation 4 23rd August 2003 01:01


All times are GMT +2. The time now is 16:40.


©2001-2018 - Baanboard.com - Baanforums.com