WampServer

Hi,

I just want a user to be able to Browse and Empty just 1 table.
Nothing more.
What for Table-specific privileges do I have to select for the user?



Edited 2 time(s). Last edit at 06/07/2009 02:51AM by Rirre.

u need to make a user just for that table , and then block all privlegees execpt delete

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 06/09/2009 12:12AM by stevenmartin99.

Not working at all.

what ?
where are you doing it

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hi,

Do you use this user from a script (with mysql_connect or others) or is it to connect to phpMyAdmin ?

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Connect to PhpMyAdmin.

worst description of a problem iv ever seen on this forum. how could anybody attempt to help you with such bad input

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

I guess you wanted to setup a particular user can only access to a particular db??? if so, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

@stevenmartin99:
Good to be the first one then.
Do you have to flame because of that just because i'm a newbie?
It wasn't even needed to post that at all since that wasn't a part of any help related to this thread.
You understand what I mean so why flame about the title?

@yfastud:
Isn't "table" in the title enough?



Edited 8 time(s). Last edit at 06/08/2009 11:11PM by Rirre.

cos "it doesnt work at all" doesnt say what u did and were it went wrong


stating ur a newbie may help in your first post - that way id know the level of detail to give

the sql code is

GRANT DELETE ON database.tablename TO 'username'@'localhost';

in phpmyadmin u can click "SQL" and just insert this code changing the 3 pieces of info db,table , user

-------------------------------------------------------------------------------------------
to achieve this in phpmyadmins menu...

Click Privledges --edit the user....

go down below the "global privledges" to

"database specific privileges"

change "use text field" to the name of the database


the page will reload


go down below the "database privledges" to

"table specific privileges"

change "use text field" to the name of the table

the page will reload


By deafault the user will get select,insert etc so tick "None" below each of the four white boxes

Then select the "DELETE" option and press go
----------------------------------------------------------------------------------------------


The EMPTY function actually calls TRUNCATE to run but it requires the DROP PRIVELEDGE. - You wont want anyone dropping the entire table. so you will need to use DELETE PRILEDGE


the command to empty the table using DELETE is

press "SQL" and use this code

DELETE FROM database.table


this will empty the table.

NOTE: There is no way of using the "empty" button without giving the DROP Privledge

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 06/09/2009 12:11AM by stevenmartin99.