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

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 [Quoted] 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.

[Quoted] 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 [Quoted] deal with UNIX SysAdmins and Oracle DBAs that take a more careful approach than [Quoted] stability, security, and scalability than that with which he may be familiar. I [Quoted] can tell you for a fact that the rules at more than a few Fortune 500 companies [Quoted] in the US would never allow what you suggest. They would just refuse to purchase [Quoted] 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)