Re: Database permissions

Dhanesh K Veedu wrote: > > 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 That's pretty much the only way, as far as I know. Anyone who has raw SQL access can use CREATE DATABASE. You can tell them not to, and using the informix password you can ruthlessly exterminate any databases they create (or make a shell script to do this). They will get the message eventually. I tried telling people "don't create databases" - especially because they often forget to specify a dbspace and create them in the root dbspace (which is the default). This was not effective enough. Dropping their databases without even bothering to find out what they were, and giving the creator a good slapping is more effective and more fun too. Or as you phrase it "telling them to stop personally". If deja is working you will find some old discussions of this in c.d.i. -- Usenet, a global collection of flaming opinions and senseless babble, was designed as a way to eat up precious spool space on a system's hard drive. It also is a way for people to distribute pornography. (By Robert A. Hayden <www.geekcode.com>)