Chris Jones wrote: > Can the mysql administrator grant permissions on a table in an existing > database if that table doesn't exist yet? This is part of planning for an > upgrade to an existing application. The mysql administrator won't be there > when I add the table to the existing database and I don't have grant > privileges.
You can't do this using a grant statement because it is bound by existing tables. You may be able to manipulate the mysql db tables directly - I was able to insert a row in mysql.tables_priv for a nonexistent table - but I don't know how this will play out once the table actually is created. Perhaps give it a try on a test db...? David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
