With Oracle you can set limits to users. I don't think this is possible with MaxDB.
You could do reports like select user, count(*) from your_table to see which user takes up how much space of the table. If you combine this with information about the whole table's size you can even calculate MB a certain user uses. robert 2005/9/19, Ralf Schneider <[EMAIL PROTECTED]>: > Hi, > > I've a Java application on top of MaxDB. This application provides accounts > for different users. All my tables have the userID as column to distinguish > the data of the users. > > I want to track how much DB space is used by each user for checking the > current usage against a defined limit. How can this be done? I didn't find > anything about that in the docs. Or did I miss something? > > Any hints would be appreciated, > Ralf. > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
