Re: preventing users from creating databases

Bill, this is one of the reasons why you want to use server based ODBC drivers where these things can be controlled on the server (like you can with the OpenLink drivers). Informix should also have implemented solutions for these kinds of problems, but haven't adressed them yet. wjd@sky.net (Bill Dillinger) wrote: :So that would work for host-based users, but not for client users, i.e. :Powerbuilder users working on PC's. My real concern is not people :using Powerbuilder, because they would be bonafide developers, but :rather people with other database friendly apps. I know you can query :data from Lotus, and I wouldn't be suprised if you could create :databases too. If not now, I'm sure in the future there will be a :myriad of PC based applications that will allow one to do that. :Therefore, I can't hope to control the user application and wanted to :try to control the server side of things. I can just image some Pc :user dabbling in WordPerfect and unknowingly creating databases on :my server. This is especially a concern, because the developers were :wanting to create a generic id on the system to allow users access :without hving to create and maintain a unique id for each of them. :Then I wouldn't even be able to track who was doing what? I am opposing :that, but looking for insurance to CYA anyway. Thanks for the suggestion. : :On Wed, 22 Jan 1997 Kate_Tomchik@HomeDepot.COM wrote: : :} :} :} We have revoked permission from all users to dbaccess and isql in :} production environments to solve this. :} :} :} :} (Embedded :} image moved iac @ frc.com :} to file: 01/17/97 06:40 AM :} PIC14918.PCX) :} :} :} :} :} Please respond to iac@frc.com :} :} To: wjd @ sky.net :} cc: informix-list @ rmy.emory.edu (bcc: Kate Tomchik/IS/SSC/THD) :} Subject: Re: preventing users from creating databases :} :} :} :} :} 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