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. But there are database systems which don't have it, so why do you think that this could become a generic getFields()? Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
