Re: Ayuda sobre performance

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/