Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to give a user access to only a few tables. I execute this query:

GRANT SELECT (credits_features_csgo, steam_code, credits_csgo, userid,
     credits_forum, credits_features_tf2, credits_tf2, credits_css, credits_features),
INSERT (credits_features_csgo, steam_code, credits_csgo, userid, credits_forum,
     credits_features_tf2, credits_tf2, credits_css, credits_features), 
UPDATE (credits_features_csgo, steam_code, credits_csgo, userid, credits_forum,
     credits_features_tf2, credits_tf2, credits_css, credits_features),
CREATE,
REFERENCES (credits_features_csgo, steam_code, credits_csgo, userid, credits_forum,
     credits_features_tf2, credits_css, credits_features),
ALTER
ON `bob_forum`.`vb_user`
TO 'bob_store'@'localhost';

It executes successfully, but when I go to check the user's privileges, it only shows it being granted usage. What would be causing this issue?

share|improve this question
What DB engine are you using? – Ali Razeghi Nov 29 '12 at 5:16
MyISAM is what I am using. – user1811105 Nov 29 '12 at 5:22
Ah! Too old for me, I'll await someone who has experience with it. :) – Ali Razeghi Nov 29 '12 at 5:24
Breaking your SQL command into several lines makes your question much easier to read. – trygvis Nov 29 '12 at 6:44

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.