Uwe Grauer wrote: > Carl Karsten wrote: >> My getFields() test failure turned out to be inconclusive. So I am back to >> thinking that I have created a generic getFields(). >> >> But it assumes the user has read access to the INFORMATION_SCHEMA db. >> >> Can I get some stats on how many people can run this, and how many get any >> access violation or other errors: >> >> mysql> select count(*) from INFORMATION_SCHEMA.COLUMNS; >> +----------+ >> | count(*) | >> +----------+ >> | 513 | >> +----------+ >> 1 row in set (0.04 sec) >> >> And/or give me your interpretation of: >> >> The Information Schema views are defined as being in a schema >> named >> INFORMATION_SCHEMA, enabling these views to be accessed in the >> same >> way as any other tables in any other schema. SELECT on all of >> these >> views is granted to PUBLIC WITH GRANT OPTION, so that they can be >> queried by any user and so that SELECT privilege can be further >> granted on views that reference these Information Schema views. No >> other privilege is granted on them, so they cannot be updated. >> >> The Information Schema also contains a small number of domains on >> which the columns of the Definition Schema are based. USAGE on all >> these domains is granted to PUBLIC WITH GRANT OPTION, so that they >> can be used by any user. >> >> >> I think that means I can rely everyone having read access, but I am biased: >> I >> want to relay on it. >> >> TIA >> Carl K > > INFORMATION_SCHEMA does exist in some database systems.
Please give an example. > But there are database systems which don't have it, so why do you think > that this could become a generic getFields()? Because INFORMATION_SCHEMA is defined in the sql-92 spec. Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
