Hola a todos, quisiera me pudiecen ayudar con esto que les voy a
presentar:

necesito saber como puedo ver los usuarios que tengo y los privilegios
de los mismos.
asi como el sacar estadisticas de rendimiento de la base de datos o de
accesos.
Gestor, claro, Informix, Sistema Operativo UNIX

el onstat me prodria ayudar????
o si hay otra manera mencionenla plis!

espero y me puedan ayudar con esto.

On 3 Aug 2006 21:49:42 -0700, alberto.jsp <alberto.jsp@gmail.com> wrote:
>
> Hola a todos, quisiera me pudiecen ayudar con esto que les voy a
> presentar:
>
> necesito saber como puedo ver los usuarios que tengo y los privilegios
> de los mismos.
> asi como el sacar estadisticas de rendimiento de la base de datos o de
> accesos.
> Gestor, claro, Informix, Sistema Operativo UNIX
>
> el onstat me prodria ayudar????
> o si hay otra manera mencionenla plis!
>
> espero y me puedan ayudar con esto.


This list operates primarily in English - questions in other languages often
languish unanswered for a while until someone musters the energy to
translate.

The BabelFish (http://babelfish.altavista.com/) converts your message from
'Spanish' to 'English' as:

Hello to all, it wanted pudiecen to help to me with which I am going to them
to present/display: I need to know like I can see the users who I have and
the same privileges of asi as removing estadisticas of yield of the access
or data base. Manager, sure Informix, Operating system UNIX onstat prodria
to help me? or if mencionenla is another way plis! I hope and they can help
me with this.


Which, being roughly paraphrased, might be one of two somewhat different
requests:
* I would like to see which users have access to the database and what those
privileges are.
* I would like to see which users have the same access permissions on the
database as me.
The subsidiary information - using Informix (and, by inference, IDS) on Unix
- is useful, though not complete.

For both of these questions, I would regard the per database system catalogs
as the source of the information. Which tables you look at depends on which
version of IDS (7.31 vs 9.x or 10.x). The fundamentals are the same -
sysusers, systabauth, sysprocauth (syscolauth). There are other 'auth'
tables in IDS 9.x and 10.x to look at too.

In neither case would I regard onstat as a source of information, but I'm
not at all sure I can paraphrase the latter parts of the translation
sensibly.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/