How to add a new user to Informix Database?

5089 views
Skip to first unread message

Khanh K Mai

unread,
Nov 19, 1998, 3:00:00 AM11/19/98
to
I have gone through the Administrator's Guide of Informix Online
documentation
at informix.com web site and still did not get enough information about
how to
add a new login user to Informix Database.

I mean that I would like to know those Informix DBA commands performing
similar Sybase commands like :

sp_addlogin "joe" , "joe_passwd"
go
use tester_database_name
go
sp_adduser "joe"
go

Thank you very much for your help

kmai


Steve

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to
With Informix you do not add users, this is impli


The user account is established or created through the Operating
System (OS) when their login id is established.

All users are put into the "public" group.

You can then use the "grant" and "revoke" commands to control the
users permissions.

Steve
.
On Thu, 19 Nov 1998 09:51:08 -0600, Khanh K Mai <km...@vertex.com>
wrote:

Yang, Heung-Soon

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to
Informix Uses account from OS.
You just can give users(who already have accounts for the platform ) some
previligies.

Have a Nice day !!

Yang, Heung-Soon

unread,
Nov 20, 1998, 3:00:00 AM11/20/98
to

Sean Kelsey

unread,
Nov 23, 1998, 3:00:00 AM11/23/98
to
You don't really access the Informix database using a login and password.
The way in which Informix security works is by giving privilages to users
using the GRANT command ( found in Informix documentation ).

GRANT DBA TO JOE

grants full DBA privilages whereas

GRANT INSERT ON tablename TO JOE

allows JOE to insert data to the table tablename

JOE MUST exist as a known user on the system i.e. must have a login name
and password.

If you have any other problems, give me a call.

Sean

Khanh K Mai <km...@vertex.com> wrote in article
<36543E6C...@vertex.com>...

Sean Kelsey

unread,
Dec 2, 1998, 3:00:00 AM12/2/98
to
Sorry Khanh, I have been unable to respond via e-mail - problems at my end
!!!

To add users on the system, you'll have to go through the UNIX system admin.
Simply add them as part of the informix group. Once they are recognised by
UNIX then you can grant and revoke permissions accordingly. ( I trust this
is a UNIX box ?? ).

NT works in a similar way, but you will need to navigate your way around the
security labarynth before users can use the relevant chunks/databases.

Hope this helps

Sean


Khanh K Mai wrote in message <36543E6C...@vertex.com>...

Nigel Gall

unread,
Dec 2, 1998, 3:00:00 AM12/2/98
to

Hi!

This has appeared so many times on the list, and the instructions are
also in the manuals. Yet some of us still add new users to the UNIX
group informix. PLEASE REFRAIN FROM DOING SO! This compromises the
security in terms of access to the applications. Only user informix
should be a member of the group informix.

To use INFORMIX applications in UNIX, you create your new user using the
normal UNIX Account Manager utility (whatever that may be on your
flavour of UNIX). Then you modify the user's ,profile or .login (or
maybe if the box is to be used by all users as a database application
server, then you may want to do this in /etc/profile so that it is done
once) to add the specific environment variables based on your version of
the engine. For pre-6.x you need:

- INFORMIXDIR=<home directory where the INFORMIX applications were
installed>
- PATH :- needs to have $INFORMIXDIR/bin included in PATH
- SQLEXEC :- only needed if multiple engines (SE and OnLine) installed
in INFORMIXDIR

For 6.x and above:

- INFORMIXDIR
- PATH
- INFORMIXSERVER :- check the manuals

There may be other variables needed, but you need to check your DBA or
System Admin for them. If you're the DBA, then you need to attend an
INFORMIX Training course for your engine version, because there are a
lot of things to read about and learn if you're going to do anything for
yourself (and your users).

In this respect, INFORMIX is unlike the other database offerings, in
that users are not created in the INFORMIX environment; rather your UNIX
user has certain environment variables set so that they can access
certain database objects via certain INFORMIX applications, and your DBA
needs to set the correct permissions/access rights at the database level
(and table if needed).

Hope this helps. I'm not familiar with INFORMIX for NT so I can't help
you there.

Best regards,

Edmund Nigel Gall
Information Systems Specialist
Process Plant Services Limited
Atlantic Avenue, Point Lisas Industrial Estate
Point Lisas, Couva, Trinidad & Tobago, W.I.
Tel: (868) 636 3153 Fax: (868) 636 3770

Kurt Wall

unread,
Dec 3, 1998, 3:00:00 AM12/3/98
to
Using recycled bits, Sean Kelsey blurted out:
%Sorry Khanh, I have been unable to respond via e-mail - problems at my end
%!!!
%
%To add users on the system, you'll have to go through the UNIX system admin.
%Simply add them as part of the informix group. Once they are recognised by
%UNIX then you can grant and revoke permissions accordingly. ( I trust this
%is a UNIX box ?? ).

Only the `informix' user should be a member of the `informix' group.
Doing otherwise compromises your data integrity. User of database A
can inadvertently modify the contents of database B. The recommended
approach is to set the appropriate environment variables for database
access in each individual user's .profile (.login, .whatever), or
use a global init script that accomplishes the same thing. Of course,
you still have to use UNIX utilities to create the user. :)

%NT works in a similar way, but you will need to navigate your way around the
%security labarynth before users can use the relevant chunks/databases.

`NT' and `works' in the same sentence? Hmmm.

Kurt
--
Kurt Wall
Informix on Linux FAQ - http://www.xmission.com/~kwall/iolfaq.html
Spanish Translation - http://www.xmission.com/~kwall/iolfaqsp.html

erwan dermawan

unread,
Aug 26, 2021, 3:30:36 AM8/26/21
to
Pada Senin, 23 November 1998 pukul 15.00.00 UTC+7, Sean Kelsey menulis:
> You don't really access the Informix database using a login and password.
> The way in which Informix security works is by giving privilages to users
> using the GRANT command ( found in Informix documentation ).
> GRANT DBA TO JOE
> grants full DBA privilages whereas
> GRANT INSERT ON tablename TO JOE
> allows JOE to insert data to the table tablename
> JOE MUST exist as a known user on the system i.e. must have a login name
> and password.
> If you have any other problems, give me a call.
> Sean
> Khanh K Mai <km...@vertex.com> wrote in article
> <36543E6C...@vertex.com>...
> > I have gone through the Administrator's Guide of Informix Online
> > documentation
> > at informix.com web site and still did not get enough information about
> > how to
> > add a new login user to Informix Database.
> >
> > I mean that I would like to know those Informix DBA commands performing
> > similar Sybase commands like :
> >
> > sp_addlogin "joe" , "joe_passwd"
> > go
> > use tester_database_name
> > go
> > sp_adduser "joe"
> > go
> >
> > Thank you very much for your help
> >
> > kmai
> >
> >
halo help me plisss

about db informix

my problem not connected informix (server centos 7) to apk daver
Reply all
Reply to author
Forward
0 new messages