Dear List,
My system is RedHat EL3 and MySQL 5.0.7-beta.
I wanted to implement a check constraint (below), but after some testing
and googling, it seems I can't do this with MySQL. I've read suggestions
that check(s) should be done using triggers. Is a trigger a preferred
method of achieving the
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)
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
)/1234567*100 AS Percentage
FROM tblIp
GROUP BY SrcIp;
Chris Andrew
Oxspring Network Solutions Limited
Tel: +44 (0)1226 761188
Fax: +44 (0)1226 761199
Email: [EMAIL PROTECTED]
Web: www.oxspring.com
-
Before posting, please check