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
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
>
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