I can't remove it! So, the question is,
how can I revoke all the permissions that have been applied to a database
(recursing into table/columns etc.) ?
Many thanks,
Steve :)
--
View this message in context:
http://www.nabble.com/Problem-revoking-all-privileges-t1183423.html#a3115859
Sent from
: http://www.nabble.com/Problem-
revoking-all-privileges-t1183423.html#a3115859
Sent from the MySQL - General forum at Nabble.com.
If you had checked the manual, you would have seen that your statement's
syntax is missing the name of the user whose privileges you are trying to
revoke.
REVOKE
, but this is not
ideal. I suppose I could export host_privs, do some jigery-pokery with
sed/awk and formulate all the possible privs to remove, but that just seems
too long-winded.
I hope this explains the problem better,
Thanks,
Steve :)
--
View this message in context:
http://www.nabble.com/Problem-revoking