Re: preventing users from creating databases
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
} }
}
}