query killing system

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

I was informed today that we had a user that created and ran  a
query(query400) that creates a database file.  Obviously there was a flaw in
their query and as a result disk usage shot up to over %90.

I 'm trying to figure out we can prevent this from happing in the future.
We do try to impower the users to create queries as we are a small shop, but
we can't have them bringing the sytem to its knees either.

I know i could change CHGQRYA on the time limit but not sure if that is the
best route.

Any ideas.

Thanks

Mike