create user
Question: must a UNIX account exist for someone to connect to an Informix database? The poster had done GRANT CONNECT and GRANT ALL for a new user but access only worked after creating the user with useradd. Answer given: yes — the user must exist on the UNIX box where the server runs and must have a home directory, since Informix relies on OS authentication; however, the account need not be login-able (no valid password required). A follow-up asking what the Informix password would be for such a password-less account went unanswered in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, do you have to create a standard user account on a unix box, if yu want to connnect to an Informix DB? I did "grant connect to newuser" and "grant all on mytable to newuser" I still can't access the database. If I create the user on the unix box "useradd newuser" it works. Is there some other way to connect to Informix without an unix account? Thanks Benno
Benno Eiwen wrote: > > Hi, > > do you have to create a standard user account on a unix box, if yu want to > connnect to an Informix DB? > > I did "grant connect to newuser" and "grant all on mytable to newuser" > I still can't access the database. If I create the user on the unix box > "useradd newuser" it works. > > Is there some other way to connect to Informix without an unix account? The user must exist on the UNIX system where the server resides and has to have a home directory, HOWEVER, the account does not have to be login-able (ie need not have a valid password). Art S. Kagel
In article <36FFB0AB.2CDD@bloomberg.net>, kagel@bloomberg.net wrote: > Benno Eiwen wrote: > > > > Hi, > > > > do you have to create a standard user account on a unix box, if yu want to > > connnect to an Informix DB? > > > > I did "grant connect to newuser" and "grant all on mytable to newuser" > > I still can't access the database. If I create the user on the unix box > > "useradd newuser" it works. > > > > Is there some other way to connect to Informix without an unix account? > > The user must exist on the UNIX system where the server resides and > has to have a home directory, HOWEVER, the account does not have to be > login-able (ie need not have a valid password). > > Art S. Kagel > Could you please elaborate on the user will have unix account and a home directory but not have a vaild password. What is the Informix password then for that user, if the unix account does not have a valid password? Thanks, Randy rlwlody@promarkone.com -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
In article <36FFB0AB.2CDD@bloomberg.net>, kagel@bloomberg.net wrote: > Benno Eiwen wrote: > > > > Hi, > > > > do you have to create a standard user account on a unix box, if yu want to > > connnect to an Informix DB? > > > > I did "grant connect to newuser" and "grant all on mytable to newuser" > > I still can't access the database. If I create the user on the unix box > > "useradd newuser" it works. > > > > Is there some other way to connect to Informix without an unix account? > > The user must exist on the UNIX system where the server resides and > has to have a home directory, HOWEVER, the account does not have to be > login-able (ie need not have a valid password). > > Art S. Kagel > Could you please elaborate on the user will have unix account and a home directory but not have a vaild password. What is the Informix password then for that user, if the unix account does not have a valid password? Thanks, Randy rlwlody@promarkone.com -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own