ssword';
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 PROTEC
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
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: R
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 b