Re: Alpha 4.1-Temporary Tables-Alter/Update

2003-07-22 Thread Peter Gorelczenko
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

Re: Alpha 4.1-Temporary Tables-Alter/Update

2003-07-22 Thread Egor Egorov
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 >

Alpha 4.1-Temporary Tables-Alter/Update

2003-07-22 Thread Peter Gorelczenko
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