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
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
