Thanks Gurham, I'd considered your second idea - but I prefer your first idea. So I decided to give the user a table prefix of tbl_R - however, the following throws an error:
mysql> GRANT CREATE ON Personnel.tbl_R* TO MyUser IDENTIFIED BY 'a_password'; Error 1064: You have an error in your SQL syntax near '* ..... blah .... Checking the manual, I'm not sure I can do this ?? Regards, Chris > -----Original Message----- > From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] > Sent: 01 May 2002 15:44 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: CREATE and DROP Privileges > > > 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