|
Hrm, that looks screwed up.
If you only have UPDATE privilege, you cannot do any inserts. You could try REPLACE INTO which will look for a matching row (on primary key) and if none is found it will do an insert, but I'm not sure that will work anyways (because you still have no insert privilege).
However even worse than that, is this one:
Grant table level selection on shipments relation.
Insert into shipments the row S5, P8, J5, 40.
If you only have select privilege, then you can definately not insert data.
What MySQL version are you allowed to work with? Maybe you can do something with stored procedures, triggers, cascades, etc...
__________________
Skype variuscr - Email varius AT gmail
|