Re: I can attach in SQL Server, but can I in Oracle?

[Quoted] [Quoted] While I have a "superior" product (if I do say so myself <G>), my customers [Quoted] drive my product's design and I do everything possible to make sure that I [Quoted] cause "minimal" hate and discontent within the client's organization (i.e., user vs. I/T department).

Given the level of security and caution that most of my clients have, I wouldn't be able to do much more than give them either the scripts or a database "file" -- with SQL Server, I detach a copy of the master database and copy it to the CD. It is then the responsibility of the client's SQL Server DBA to copy it to the appropriate location and to attach it to their server -- I've only tried to make it easier for them to get the "cleanest" and "friendliest" installation possible.

They pay too much for my software for me to jeopardize any sale. FWIW, my software sells between $5k and $30k per client. I developed and sold a PC-based product that sold for $680k per copy so you can be sure I don't screw around with those types of clients at all ... this one is a very specialized standalone engineering application.

Ron

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F382A80.F280CC37_at_exxesolutions.com...
> Maximus wrote:
>
> > <snipped>
> >
> > I gather Ron's intention is an automated way to install his application
on
> > an Oracle server. Why does one need the services of both a DBA and an
> > administrator to do this? For example, if he is using ODBC/ADO, the
> > Microsoft Oracle driver will allow him to execute native Oracle SQL
> > commands, making it possible to script the entire creation of schema,
> > populate tables, grant rights, create objects... whatever necessary, and
> > completely without the services of a DBA or administrator.
>
> Depends on whether the SysAdmin and DBA are fools enough to set things up
so
> that someone with ODBC can log on and create users, assign roles, system
> privileges, modify profiles, consumer groups, etc. I can't think of any
> organization where I have been in the last six or seven years that would
allow
> that to happen.
>
> And anyone that does needs a good solid lesson in security.
>
> If Ron wants to work with Oracle clients he is going to have to be
prepared to
> deal with UNIX SysAdmins and Oracle DBAs that take a more careful approach
than
> stability, security, and scalability than that with which he may be
familiar. I
> can tell you for a fact that the rules at more than a few Fortune 500
companies
> in the US would never allow what you suggest. They would just refuse to
purchase
> the product. And lets be honest here.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Tue Aug 12 2003 - 05:44:06 CEST