Print SQL information

New joke in IDS by IBM. [cnzp@chvl02 cnzp]$ onstat -g sql IBM Informix Dynamic Server Version 9.40.UC4 -- On-Line -- Up 1 days 03:43:16 -- 721340 Kbytes Must be a DBSA to run this program

Why do you think it is a joke? (I can think of some reasons, but I'd like to hear yours.) In general, ordinary users should not be able to see other people's SQL statements -- it could reveal confidential information, like identifier numbers (SSN in the US, other equivalents elsewhere), or passwords, or ... So, it is entirely appropriate that only privileged users should be able to see SQL statements. We can debate whether the DBSA group is the most appropriate group when there is role separation in use. You can seriously expect that the visibility of SQL will be restricted more in future - the DBSA (database system administrator - usually members of group informix) will be able to see it, and no others. There is at least some room for argument that it should be more restricted than that. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" "ALES PLACHY" <ales.plachy@pvt.cz> Sent by: forum.subscriber@iiug.org 06/09/2004 04:25 AM To ids@iiug.org cc Subject Print SQL information [3087] New joke in IDS by IBM. [cnzp@chvl02 cnzp]$ onstat -g sql IBM Informix Dynamic Server Version 9.40.UC4 -- On-Line -- Up 1 days 03:43:16 -- 721340 Kbytes Must be a DBSA to run this program