Carl Karsten wrote: > 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 >
Firebird and sqlite for example doesn't have this. Besides of this there are security reasons not to let everyone have access to the INFORMATION_SCHEMA views. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
