So, CREATE TEMPORARY TABLES only allows the initial create and insert into a temporary table. Any other privileges like alter, update, delete, and possibly drop are reserved for real tables and database grants.
Don't get me wrong, I'm glad we have the create temp table grant/option. We can accomplish what we are trying to do by creating a series of temp tables and join them together. They are relatively small tables. It just would have been slick via the update and Alter syntax. Thanks for the time. Pete On Tuesday 22 July 2003 10:56, Egor Egorov wrote: >Peter Gorelczenko <[EMAIL PROTECTED]> wrote: >> Good Morning, >> I'm running Alpha 4.1 on Linux. I'm new to MySql but familliar with other >> databases. I set up a user with "Create Temporary Tables" permissions. >> That user can create temp tables but can not alter or update the table. >> That user is getting "Update command denied to user..." for the temp >> table. They also get this error when an alter table is executed. Doesn't >> the user have ownership of the temp table they create? If they do then >> why can't they alter/update it? Am I missing something? > >CREATE TEMPORARY TABLES privilege allows only create temporary tables. -- This email may contain CONFIDENTIAL or PRIVILEGED information and is a private communication between the intended addressee and PharMetrics, Inc. If you have received this email in error, reading, copying, using, or disclosing its contents to others is prohibited. Please notify us of the delivery error by replying to this message, and then delete it from your system. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]