i have a database with few precreated tables.
i need to create new username that needs to access this database and to have full access to create and delete tables, except the precreated ones.
so, for example i have pretable1 and pretable2 created and i want to give the user read-only access to these tables, but also rights so user can create new tables and then to delete newly created tables.
how can i do this? just to mention, as maybe it is relevant to the issue, the tables user needs to create are temporary tables (TYPE=HEAP).
Thanks in advance.
MySQL permissions issue
Moderator: General Moderators