On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: > Hi all, > > I'm wondering if there is some way to setup privileges in the grant > tables such that a user can create or drop any arbitrary table in > databases that user is associated with, but be unable to create or drop > the databases themselves. I was hoping the tables_priv table would come > to my rescue, but the MySQL documentation claims that you can't specify > wildcards in the table_name column.
Give them CREATE and DROP privileges on the databases you'd like them to be able to mess with. http://www.mysql.com/doc/en/GRANT.html Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.8: up 59 days, processed 2,009,667,903 queries (390/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
