Re: granting privileges using wildcards

[Dimitar Haralanov]

On Wed, 26 Mar 2003 13:14:09 -0600
Black, Kelly W [PCS] wrote:

   > I think this might do what you want, but then you will be required
to log
   > in with the -p syntax...
   > 
   > GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword";
   > 
   > FLUSH PRIVILEGES;
   > 
   > mysql -u youruserid -p -h hostname dbasename

        Well, as far as I know SQL and MySQL this will grant select option to
user 'yourlogin' from any host to any database and any table.

        What I wanted is that the user will have select privileges on on tables
'table_*' from database db.
        Basically, is something like the following possible?

        GRANT SELECT ON db.table_% TO user@'%' IDENTIFIED BY 'pass';

        Thanx
                -- Mitko

pgp00000.pgp
Description: PGP signature