Consultation of Privileges
A
consultation of Privileges:
When the instance is created, by default it is initialized with the tables
of the system: to sysmaster and sysutils.... these are created with the
following privileges:
select *from sysmasterinformix D
public C
select *from sysutilsinformix D
public C
root D
The question is: IN THESE DATA BASES, I CAN ELIMINATE THE CONNECT PRIVILEGE
GROUP PUBLIC WITHOUT IT HAS IMPACT FOR THE EXISTING APPLICATIONS?
Thanks
_________________________________________________________________
Las mejores tiendas, los precios mas bajos, entregas en todo el mundo,
YupiMSN Compras: http://latam.msn.com/compras/
Dear Dooku,
this depends on what your applications do.
If they don't access neither sysmaster nor sysutils, it will not affect
these applications.
Also, if they connect as informix resp. root it won't affect them either.
However, if your applications connect to sysmaster to get system
information for monitoring etc, these
parts of your application will probably fail.
SAP R/3 e.g. makes use of the sysmaster tables a lot to display DB and
system information
inside the R/3 system.
However, you still may add a right to connect for specifically the user
that tries to connect through your
application .
Regards
Tilman
--
Tilman Model-Bosch
IBM Data Managment Solutions, Informix Advanced Support
c\\\\o SAP AG
TECHDEV 05
Neurrotstr.16
69190 Walldorf
forum.subscriber@iiug.org wrote on 10/11/2004 00:51:36:
> A consultation of Privileges:
> When the instance is created, by default it is initialized with the
tables
> of the system: to sysmaster and sysutils.... these are created with the
> following privileges:
> select *from sysmaster> informix D
> public C
>
> select *from sysutils> informix D
> public C
> root D
>
> The question is: IN THESE DATA BASES, I CAN ELIMINATE THE CONNECT
PRIVILEGE
> GROUP PUBLIC WITHOUT IT HAS IMPACT FOR THE EXISTING APPLICATIONS?
>
> Thanks
>
> _________________________________________________________________
> Las mejores tiendas, los precios mas bajos, entregas en todo el mundo,
> YupiMSN Compras: http://latam.msn.com/compras/
>
>