CREATE and DROP Privileges

2002-05-01 Thread Chris Andrew
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)

RE: CREATE and DROP Privileges

2002-05-01 Thread Gurhan Ozen
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

RE: CREATE and DROP Privileges

2002-05-01 Thread Chris Andrew
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

Re: CREATE and DROP Privileges

2002-05-01 Thread Victoria Reznichenko
Chris, Wednesday, May 01, 2002, 5:18:47 PM, you wrote: CA I have a user account that needs to create and subsequently drop tables (not CA temporary tables). CA Is it possible to give permissions to this user to drop just the tables that CA he creates - without allowing him to drop any other

RE: CREATE and DROP Privileges

2002-05-01 Thread Gurhan Ozen
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