Re: preventing users from creating databases
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).
}
} 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
} } >
} }
Currently, the method we use to prevent developers/users creating databases in the root dbspace is
by telling them they can't, and must ask the DBA to create one for them. As long as we create
them when they want (which isn't too often), they seem happy. "Ignorance is bliss". Potentially
for the future we may consider a script to remove unauthorised databases overnight, however, I have
not had any issues with it so far. When I first became familiar with Informix I was also concerned
with this ability of users to create databases in the root dbs, but by "mis-informing" the user
community we have avoided any trouble ! (So far!).
--
Rick Ward
Senior DBA
Great Universal Stores Home Shopping
MANCHESTER, UK