Re: Restricting database creation w/ Online 5

David Williams <djw@smooth1.demon.co.uk> wrote: :In article <nneul-ya023180001011961302510001@usenet.umr.edu>, Nathan :Neulinger <nneul@umr.edu> writes :> :>Is there any way to restrict creation of databases? It appears that anyone :>who has a userid on the database server machine can create databases at :>will in ANY dbspace... :> :>Is there any way to control this short of only allowing remote access (via :>STAR). : I'm not sure, my Online 5 manual is at work and I'm at home on :holiday. Try : revoke dba from '<username>' You can't do that without selecting a database first, so it will not help protect against the create database statement. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org