Hi there I have been battling with this stupid little thing for a while now, I want to grant privileges for SELECT,INSERT,UPDATE,DELETE to a particular user on a particular database. That works 100%. Now I want to revoke DELETE privileges for that same user on say four or five tables, but it says the privilege does not exist. I think I have worked out why, that is because when I granted I granted on Database and not table level, now I am trying to remove a table level right and it is complaining. Besides manually doing GRANT privileges for each and every table individually, is there any other quicker way of doing this? Regards Warren ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
