Re: en/disable SqlPlus HOST command?

In article <3B71A0BF.7BA90639_at_kochandreas.com>, Andreas says...
>
>Hi,
>
>one of my scripts generates several log files via SPOOL.
>At the end of the process, all of these are combined via
>
>host copy log1.tmp+log2.tmp+log3.tmp all.log
>
>Unfortunately, on some customers systems that "copy" works, and
>on some it doesn't. Oracles SQLPlus handbooks state that availability
>of this command can be configured by the DBA, but searching the
>online help for "host" doesn't help much :)
>
>How do i check if "host" will work, and enable it (with DBA rights)
>if necessary?
>
>
>--
> Andreas
>Mach's mit /-\
> |o|
> \-/ gib KIDS keine Chance! ;-)

The admins can use the product_user_profile to restrict access to this command:

http://technet.oracle.com/doc/oracle8i_816/sqlplus.816/a75664/ape1.htm#623312

its not a database privilege, its meta data stored in that table.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp