On Jan 6, 2007, at 2:07 PM, Carl Karsten wrote:
>> 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.
I logged into the public MySQL database on Paul's system, and got
the following:
[EMAIL PROTECTED]:~$ mysql -h melder.paulmcnett.com -u dabo -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12809 to server version:
4.0.24_Debian-10ubuntu2.3-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select count(*) from INFORMATION_SCHEMA.COLUMNS;
ERROR 1142 (00000): SELECT command denied to user:
'[EMAIL PROTECTED]' for table 'COLUMNS'
mysql>
Just because it's in the database doesn't mean that generic users
will have access to it. In fact, I would assume that any good DBA
would hide information about the system that the user doesn't
expressly need.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
