Re: Database permissions

Check permissions for the users. CREATE DATABASE will always create the database in sysmaster unless it isprovided another dbspace in the create statement. What I used to do was to look for these rouge databases daily and give the offending developer a day to tell me where they wanted it moved. If I could not figure out who it belonged to I just renamed it and waited to see who started to complain ;) > Hello, > > As a DBA, How do you normally prevent others from creating brand-new > databases in an existing Informix instance? I am not able to stop others > from creating new ones using any commands other than telling them to stop > personally ;-) > > Thanks > Dhanesh > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com