I wonder if this will work:
each DB should assigned a diffrent user with set of premissions ( including insert ).
a script that can revoke the inseret privilage will emarge from time to time to check the DB size.
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il--------------------------
----- Original Message -----
Sent: Thursday, May 27, 2004 8:07 PM
Subject: [GENERAL] Database Size Limiting
Is there a way to limit the size that an individual database can take up?
My understanding is that all your databases go into a file system which is your catalog cluster.
But all the databases can grow until that filesystem is full.
Is there a way to limit how big a database can be? Can you allocated space when the database is set up so you can say db1 can only be 100 MB?
Thank you!
Troy Campano