I don't think there is a way to do it.. But if you have control on the table names he is creating, you can just have a certain prefix on each table he creates and give appropriate permissions on databasename.prefix* to the user. Or else, you can create a different database exclusively to be used by the user and give the permissions only to the corresponding user.
Gurhan -----Original Message----- From: Chris Andrew [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 10:19 AM To: [EMAIL PROTECTED] Subject: CREATE and DROP Privileges I have a user account that needs to create and subsequently drop tables (not temporary tables). Is it possible to give permissions to this user to drop just the tables that he creates - without allowing him to drop any other table ? Thanks, Chris (MySQL - to satisfy your mail filter) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php