Re: Need help in configuring/install Informix
CKGeier@nwc.edu wrote:
> 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?
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,
--
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