New feather in IDS for NT version 7.3
Posted in 1998
The statement SELECT TABNAME TBNAME,OWNER CREATOR,TABTYPE TYPE,NCOLS COLCOUNT,'' REMARKS,"LABEL" LABELS from "informix".SYSTABLES T where (USER=T.OWNER or USER='informix' or exists(select GRANTEE from "informix".SYSTABAUTH where (GRANTEE= USER or GRANTEE='public') and TABID=T.TABID and (TABAUTH[1,1]='s' or TABAUTH[1,1]='S'))) and (TABTYPE = 'T') and not ((OWNER='informix' or OWNER='pcuser') and TABNAME in ('sysblobs','syschecks','syscolauth', 'syscoldepend','syscolumns','sysconstraints','sysdefaults', 'sysdepend','sysdistrib', 'sysfragments', 'sysindexes','sysopclstr', 'sysprocauth', 'sysprocbody','sysprocedures','sysprocplan', 'sysreferences','syssynonyms', 'syssyntable','systabauth', 'systables','systriggers','systrigbody', 'sysusers','sysviews', 'gtitables','gticonvert1','gticolumns', 'gtiextrtab','gtitabauth', 'gticolauth','gtisyssyntab','gtisynonyms', 'gtiindexes','gticonvert2', 'gticonvert3','gticonvert4','gticonvert5', 'gtikeys')) ORDER BY TBNAME ASC; brings server down. Any comments? Leonid. ( Leonids.Voroncovs@dati.lv )