Accessing SMI tables
Any user can use SQL SELECT statements to query an SMI table, but standard users cannot run statements other than the SELECT statement. Users who attempt to run other statements result in permission errors. The administrator can run SQL statements other than SELECT, but the results of such statements are unpredictable.
If you query the systabpaghdrs table directly,
you must specify an appropriate value for the pg_partnum
parameter.
The value is pg_partnum > 1048576
. However, if you
query the view that is associated with the systabpaghdrs table,
you do not have to specify this value for the pg_partnum
parameter.
Informix® includes the sysadtinfo and sysaudit tables. Only the user informix on UNIX or members of the Informix-Admin group on Windows can query the sysadtinfo and sysaudit tables.
Database has pseudo tables - can't build schema