MySQL Database restrictions


It is possible to use wildcards in "Database access control list" in the Usermin Module Configuration for MySQL Database.

The default in this option is:
*: *

But can I use wildcards like this:
user1: user1_*
user2: user2_*

I always use the username and the underscore in front of the database name, like this: user_dbname.
If I can use the wildcard like this then I only have to add one line for all the users databases.

Is it possible to use variables like ${USER} or ${PREFIX}?

Leif Blafors

What is the recommended setup strategy to solve this?