Re: preventing users from creating databases

I mentioned this before. I now have a few more details: Version 7.X of Online provides a utility called trusted facility. This utility allows the DBA to create audit masks for all users and/or single users. With this facility the DBA can set the action if a specified event occurs. The action can be one of 3: 1) do nothing. 2) terminate the session and 3) halt the engine. The events can be almost everything that interfaces with the engine including: create database, oninit, onmode, alter table... To prevent users from creating databases simply create a mask to check for the create database event and terminate the session. Then create a mask for theinformix ID to allow informix to create databases. Matt Bentley mbentley@xmission.com In article <5bo8o6$hrm@cssun.mathcs.emory.edu>, David_Coburn/ISG/WVUS/WorldVision_at_WVUS-NOTES@wvccg.wvus.org (David Coburn/ISG/WVUS/WorldVision) wrote: > > > |How does one prevent a user from creating a database? How can we keep > |users from creating databases in root dbspace? Informix tech supports > |says there is no way, advised to just remove them when you see them. > > They're right, you don't. And you are equally right, this isn't a > strange request, as it has come up time and time again. Informix keeps > a database of requested features, though, so ask the support rep to add > an entry for this. I'm sure it's in there. > > David >