Restricting dbcreator

Posted in 2004

Topics: Versions, Editions & End-of-Life

Rob Smith — 5 Mar 2004 01:05:09 -0800 — source: Usenet: comp.databases.informix

Hi all, I can restrict developers/contractors from creating tables within a database but is it possible to restrict developers/contractors from creating databases in an instance hoping there might be a sysmaster setting as my thumbscrews are worn out :-) IDS 7.3 uc2 thanks in advance rob

↪ replying to Rob Smith

Fernando Nunes — Fri, 05 Mar 2004 12:04:09 +0000 — source: Usenet: comp.databases.informix

Rob Smith wrote: > Hi all, > I can restrict developers/contractors from creating tables within a > database but is it possible to restrict developers/contractors from > creating databases in an instance > hoping there might be a sysmaster setting as my thumbscrews are worn > out :-) > IDS 7.3 uc2 > thanks in advance > rob There is an undocumented feature (onconfig parameter) in 9.30+ that controls this. A reason in favour to upgrade, but probably not enough. Regards.

↪ replying to Rob Smith

scottishpoet — 5 Mar 2004 09:51:37 -0800 — source: Usenet: comp.databases.informix

At some stage IDS 9.30 introduced an onconfig or an environment variable (I think its undocumented so it may disappear in the future), that you could supply which users were allowed to create databases. I think it is called something like DBCREATE_PERMISSION (strings on the oninit binary finds this in 9.30.UC3 and 9.40.UC2 on solaris). Don't believe it was ever made generally available across the 7.3 products and platforms. robert.smith@huntleigh-healthcare.com (Rob Smith) wrote in message news:<44915578.0403050105.76f50a8f@posting.google.com>... > Hi all, > I can restrict developers/contractors from creating tables within a > database but is it possible to restrict developers/contractors from > creating databases in an instance > hoping there might be a sysmaster setting as my thumbscrews are worn > out :-) > IDS 7.3 uc2 > thanks in advance > rob