Wildcards in DB name using GRANT

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Terrac

    Wildcards in DB name using GRANT

    Hello,

    What is wrong with my syntax here

    GRANT ALL ON `user\_`'%'.* TO user@localhost ;

    The Mysql Page says...
    <--snip-->
    "the `_' and `%' wildcards are allowed when specifying database names
    in GRANT commands. This means that if you wish to use for instance a
    `_' character as part of a database name, you should specify it as
    `\_' in the GRANT command, to prevent the user from being able to
    access additional databases matching the wildcard pattern..."
    </--snip-->

    THX_advance
    _terrac
Working...