Thank you all, but I haven't been able to make it work... =(
I tried the su & su - but it didn't work, there is an interesting stuff here:
[root@localhost aol32]# su - nsadmin
[nsadmin@localhost aol32]$ env | grep LIB
LD_LIBRARY_PATH=/ora8/m01/app/oracle/product/8.1.6/lib:/lib:/usr/lib
[nsadmin@localhost aol32]$ su -
Password:
[root@localhost /root]# env | grep LIB
LD_LIBRARY_PATH=/usr/local/pgsql/lib
[root@localhost /root]# su - nsadmin
[nsadmin@localhost aol32]$ su
Password:
[root@localhost aol32]# env | grep LIB
[root@localhost aol32]# su nsadmin
[nsadmin@localhost aol32]$ env | grep LIB
[nsadmin@localhost aol32]$
as su - the LD_LIBRARY_PATH is set correctly but doesn't work & as
su - nsadmin the LD_LIBRARY_PATH is set for oracle (I'm running also oracle 8.1.6) but it works also for postgres...
the postgres driver works as nsadmin but not as root
the oracle driver works well with both users...
