CODEWITHSUNDEEP
mysqlsql-grant
NeilJiang
NeilJiang

Reputation: 223

How to grant "select" on more than one table in MySQL?

i want to do something like

grant select on arpg.t_account,arpg.t_char to peeker@'localhost';

but fails, is there a way to do so?

Upvotes: 0

Views: 1190

Answers (2)

Mark Amerine Turner
Mark Amerine Turner

Reputation: 401

You can't, you can write a script to manage it for you. There is also some functionality in the MySQL admin tools to let you do it with point and click ease.

Upvotes: 1

Lauri Lehtinen
Lauri Lehtinen

Reputation: 10857

Nope. Not in a single statement. You can't even use a wildcard such as arpg.t_% here.

Upvotes: 0

Related Questions