Re: preventing users from creating databases
Posted in 1997
Topics: Storage & Space Management, Server Administration, Security, Permissions & Auditing
In article <5bo5ds$bn1@nntp.idgonline.no>,
Nils.Myklebust@idg.no (Nils Myklebust) wrote:
>This is one of the few problems with Informix.
>Anybody who have access to the engine (say via dbaccess) can create
>their own databases in whatever dbspace they want.
>
>Even though we have such users we have never had a problem with it,
>and I wouldn't be too conserned in most environements.
>
>iac@frc.com (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
>
It has been a while, but I believe with the onaudit utility you can audit for
create database and reject the request. You would have to read the manual forspecifics.
Matt Bentley
mbentley@xmission.com