This is a discussion on how to block the insert on a table within the MySQL forums, part of the Database Server Software category; --> hello , i would like to block a table, i would like that no insert is possible on a ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| hello , i would like to block a table, i would like that no insert is possible on a table ?? do you have an idea ? -- fabien http://www.fab-le-motard.com |
| |||
| Jeff Paffett a écrit : > fab le motard wrote: >> hello , >> i would like to block a table, >> i would like that no insert is possible on a table ?? >> >> do you have an idea ? >> >> > You can set privileges at table level. ok but i'm not the administrator of mysql , i'm juste a user whith some tables ... |
| ||||
| On Thu, 16 Nov 2006 19:15:58 +0100, fab le motard wrote: > Jeff Paffett a écrit : >> fab le motard wrote: >>> hello , >>> i would like to block a table, >>> i would like that no insert is possible on a table ?? >>> >>> do you have an idea ? >>> >>> >> You can set privileges at table level. > > > ok but i'm not the administrator of mysql , > i'm juste a user whith some tables ... You can't block access to something that you don't have access to the authorities of. Being able to do so would be a bug. If you don't have GRANT, you can't. (hey, that rhymes!) -- They got rid of it because they judged it more trouble than it was worth. (And considering they'd gone to great lengths to minimize its worth, I suppose they were right.) -- J. D. Baldwin |