Re: preventing users from creating databases

wjd@sky.net (William Dillinger) wrote: :Yes, that is exactly what I am saying. Not only that, but the root dbspace :is the DEFAULT location, unless you specify otherwise in your SQL. Users :who belong to the informix group have a wide range of powers, including :being able to bring the instance down and terminate processes (onmode -k :and onmode -z). No users but informix should normally belong to the informix group. One should also not create databases when logged in as informix. You should create a special DBA-user that is the only one who creates databases, tables, indexes and so on. That makes for much simpler maintenance. There may of course be situations when other users need to be allowed to do some (or even all) of these things, but you should then be aware of the extra work it creates for the DBA. Of course if you create many databases and have different DBA's for them you would want a login name for each. The key is that these logins are used only for database administration work. Non of this solves the problem of who can create databases and where they are created of course. :On Fri, 17 Jan 1997, ic wrote: : :} Are you saying that users that do not belong to the "Informix" group :} and are not the "informix" user can create databases in root dbspace??? :} :} :} :} On 16 Jan 1997, William Dillinger 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. :} > :} > I am a little but stunned at that reply. And I don't think this is an :} > strange request, so I am would be suprised if no one had ever raised this :} > question before. :} > :} > Any insight would be appreciated. :} > :} > Bill Dillinger :} > wjd@sky.net :} > :} : 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