Scott Information_schema is a virtual database only. I think it was added in MySQL 5.0.2 to comply with SQL:2003 specifications.
information_schema provides the same info as you can get from 'SHOW' commands. Every user automatically has select privs for information_schema and its not possible to perform any other action other than select on the tables within information_schema. If you have a look here http://dev.mysql.com/tech-resources/articles/mysql-datadictionary.pdf you will find a document giving more details on what information_schema is, how it works and how to use it. Regards John > I have been meaning to find out about this since I moved to mysql 5. > In version 4, I never saw the table "information schema". With it > being in version 5, I assume it was something only the root users, or > a higher level user could see. > > I now know that it shows up under any account. I will certainly go > read more in the docs about what this table is for. However, since it > seems to be important, I would assume you do not want database users > to be able to update, insert, or delete against it. > > Is the default set up in a way that database/tables are protected? > -- > Scott * If you contact me off list replace talklists@ with scott@ * > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > > ______________________________________________ > This email has been scanned by Netintelligence > http://www.netintelligence.com/email > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
