Re: Restrict CREATE DATABASE
Posted in 1997
Either we should ask Informix to modify their engine to support
database level privs or We should ask them to modify Dbaccess , not
allow
any Create procedure statement except one which is submitted by DBA
Or
Take out Dbaccess , Have your own tool ( Which is written in ESQL or
CLI)
to do what ever U want.
I have my own tool to talk to database , Which through out create
procedure for all users except Informix
BALA PEDDI
bala.peddi@fmr.com
Thomas J. Girsch wrote:
>
> Nope. This is a big problem in Informix. Not without taking away
> dbaccess/isql, which in and of itself can only be done by "hiding" it.
>
> Henrik Loeser <loeser@informatik.uni-kl.de> wrote in article
> <1997Nov17.170612@informatik.uni-kl.de>...
> > Hello,
> >
> > is there a way to confine the right to create a database to
> > a small group of users. Reading the manuals I found no way for
> > Informix OnLine or Informix Universal Server...
> > Using the auditing facility I only can get information about
> > users creating databases, but I cannot forbid it.
> >
> > Thanks,
> > Henrik
> >