Need help in configuring/install Informix

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CKGeier@nwc.edu - 29 Jul 2003 22:30 GMT

Ok, so I installed Informix on a new box, setup environments, and it seems
to be working. Woo hoo!

However, when I create a new table through dbaccess, everyone has
permissions to it as the default. On our old system, no one has
permissions to tables after they are created, unless given authority to do
so.

Do I need to install Informix with "Role Separations?" Or is it something
else? Anybody know?

C Geier
System Admin/IS support
St. Paul, MN

sending to informix-list

Reply to this Message

Mark D. Stock - 30 Jul 2003 00:20 GMT

> Ok, so I installed Informix on a new box, setup environments, and it seems
> to be working. Woo hoo!
[quoted text clipped - 6 lines]
> Do I need to install Informix with "Role Separations?" Or is it something
> else? Anybody know?

AFAIK, the only time a table has no permissions by default is when
created in a mode ANSI database. Perhaps the database on your old system
was created as mode ANSI?

Cheers,

Signature

Mark.

+----------------------------------------------------------+-----------+

| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|

+----------------------+-----------------------------------+-----------+

sending to informix-list

Reply to this Message

Francisco Roldan - 30 Jul 2003 00:37 GMT

It is always a good practice to revoke all permissions
to the user "public" when creating a new table, independent
of the fact that informix does it or not.
The best security policy is "Trust no one"
(not even Informix creators :-) )

revoke all on "owner_user".table from "public"

Regards

-----Mensaje original-----
De: Jason [mailto:emailsucks@email.com]
Enviado el: Martes, 29 de Julio de 2003 04:41 p.m.
Para: informix-list@iiug.org
Asunto: Re: Need help in configuring/install Informix

> Ok, so I installed Informix on a new box, setup environments, and it
> seems to be working. Woo hoo!
[quoted text clipped - 12 lines]
>
> sending to informix-list

What version are you coming from and what version did you go to?

Signature

Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
sending to informix-list

Reply to this Message

CKGeier@nwc.edu - 30 Jul 2003 02:34 GMT

Thanks so much everyone who has responded!

The answer may be to set NODEFDAC=yes, that seems to do the trick.
(Awesome!)
If you have other suggestions I am still open; we are moving from a server
running aix 4.3 to a new server on aix 5L and the Informix version is the
same on both,
IDS 7.31 UC3. Yea, I want 9.4 bad but it isn't going to happen yet!

C Geier
System Admin/IS support
St. Paul, MN

sending to informix-list

Reply to this Message