I'm running as normal user (not root or database owner). This user has create
temporary table priv.
show tables partial:
GRANT CREATE TEMPORARY TABLES ON `foobar0`.* TO 'foo'@'localhost' -> (foobar0
and foo are masks for the database name and user, respectively)
I created two tmp tables with i
ption. 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:
>Pete
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
