Re: preventing users from creating databases
Matt Bentley wrote:
}
} I mentioned this before. I now have a few more details:
} Version 7.X of Online provides a utility called trusted facility. This
} utility allows the DBA to create audit masks for all users and/or single
} users. With this facility the DBA can set the action if a specified event
} occurs. The action can be one of 3: 1) do nothing. 2) terminate the session
} and 3) halt the engine.
} The events can be almost everything that interfaces with the engine including:
} create database, oninit, onmode, alter table...
}
} To prevent users from creating databases simply create a mask to check for the
} create database event and terminate the session. Then create a mask for the
} informix ID to allow informix to create databases.
}
} Matt Bentley
} mbentley@xmission.com
}
} In article <5bo8o6$hrm@cssun.mathcs.emory.edu>,
} David_Coburn/ISG/WVUS/WorldVision_at_WVUS-NOTES@wvccg.wvus.org (David
} Coburn/ISG/WVUS/WorldVision) 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.
} >
} > They're right, you don't. And you are equally right, this isn't a
} > strange request, as it has come up time and time again. Informix keeps
} > a database of requested features, though, so ask the support rep to add
} > an entry for this. I'm sure it's in there.
} >
} > David
} >
Thanks for the info, I am going to look at implementing this at our
site.
--
Rick Ward
Senior DBA
Great Universal Stores Home Shopping
MANCHESTER, UK