Hi,

can somebody help me with the relation between baan's remote user and the ora_users file?

Let me explain what i want to do. I have 2 hp servers (itanium). One for baan called ap (baan4c4) and one for Oracle called db (10g).
i've created user blanchap in Baan and on unix of my ap.
i've created user blanchap in the Oracle database.
i've created user xblanchap in unix of my db.

now in Baan, my remote user should be what blanchap or xblanchap?
and my ora_users should be xblanchap:blanchap:password:baan?

Why i want to do this is because i'm installing HP msservice guard and i want to keep my password file seperate. Why? I want to make sure that the user does not login on my db server.

I just need to understand the relationship between baan user, baan remote user, unix user, ora_users and oracle user.

Can somebody help me?

Thanks

PB.

I think you're making it more complex than it needs to be.

a Baan "remote user" is only for a thick client install, which you do not (need to) have .


Just setup a unix and baan user blanchap on AP
create oracle user blanchap in Oracle

user logs into Baan and uses SQL*Net to log in as blanchap in the DB.

your ora_users would look like
blanchap:blanchap:<encrypted password>:<group>

The user never has to log into the database server itself. (as no users should ever log into a DB server...)

Thanks.

I'm using Baan.net but i think i'll convert into sql.net. Everybody (including Baan support) is saying that my life will be less complicated.

Regars.

PB

Yeah, using baannet makes it infinitely more complex.

If it's currently working i wouldn't mess with trying to get that secured.

I'd just look to getting SQL*Net up and running.

Dave