Please help me
Posted in 2012
Please help me my server details as under
OS SUSE 10 kernal ver is x86_64 2.6.16.60-0.21
Informix 11.10
we are using have telnet login for users we have made .profile of each
user to restrict user within menu 4gls no prompt for isql
we want to give ODBC this to users as per our boss inst but user can update
data by odbc with out any restrictions we have created read only user with
only select permissions we want only that user have permissions of odbc.
As per my knlowdge pam configured informix can restict for allowed user
to use that port for informix by my informix settings as under
sqlhosts
ofa_eadmin onsoctcp 172.51.100.12 4903
ofa_eadmin onsoctcp 172.51.100.12 4904
onconfig
DBSERVERNAME ofa_eadmin # Name of default database server
DBSERVERALIASES ofa_eadmin1 # List of alternate dbservernames
new setting i have tried as under
new sqlhosts
ofa_eadmin onsoctcp 172.51.100.12 4903
s=4,pam_serv=(odb_pam_
services),pamauth=(password)
ofa_eadmin1 onsoctcp 172.51.100.12 4904
s=4,pam_serv=(odb_pam_service),pamauth=(challenge)
odb_pam_services and odb_pam_service file contents
auth required pam_listfile.so onerr=fail item=group sense=allow
file=/etc/login.group.allowed
#inst by paresM-1.0
#auth sufficient pam_rootok.so
auth include common-auth
account include common-account
password include common-password
session include common-session
session optional pam_xauth.so
login.group.allowed now this file is having all groups but my informix
unable to under stand this files eigher sqlhost or odb_pam_service
after this changes only root and informix are able to connect to database
--20cf307f34008b6ad704c6d183ef