Bug #6194 GRANT ... WITH MAX_DISC_SPACE 50M;
Submitted: 21 Oct 2004 8:40 Modified: 8 Feb 2006 12:22
Reporter: [ name withheld ] Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:coming releases OS:Any (all os)
Assigned to: CPU Architecture:Any

[21 Oct 2004 8:40] [ name withheld ]
Description:
To have the full control on user ressources, it should be possible to limit and / or count

o the maximum number of databases (okay, it's already possible if you don't give privileges to create databases - but it's human work, should be automated in our age)
o the maximum size of a database (yes, the file system does - but we need smaller, individual limitations...)
o the port traffic (bytes) of up- and downstreamed data (counted to be red and then flushed by a statistic tool every night f.e.) for the local host _and_ external hosts
o the number of rows a user can receive within a time square

for each user and / or database. Would be very useful, an important step - shure you already know, but...

How to repeat:
For example:

INSERT ...
INSERT ...
INSERT ...
... repeat until you get:
Out of disc space!

;o)

Suggested fix:
Please include more user and / or database limitations.
[8 Feb 2006 12:22] Valeriy Kravchuk
Thank you for a reasonable feature request. The ability to restrict resources for users, some more detailed form of quotas for different resouces (or resource profiles) will be useful in some environments.