Unix Technical Forum

how to block the insert on a table

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


Go Back   Unix Technical Forum > Database Server Software > MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 08:36 AM
fab le motard
 
Posts: n/a
Default how to block the insert on a table

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 08:36 AM
Jeff Paffett
 
Posts: n/a
Default Re: how to block the insert on a table

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-28-2008, 08:36 AM
fab le motard
 
Posts: n/a
Default Re: how to block the insert on a table

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 ...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-28-2008, 08:36 AM
Peter H. Coffin
 
Posts: n/a
Default Re: how to block the insert on a table

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:44 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com