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)
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
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
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
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