From: Thomas Kyte <tkyte@us.oracle.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: en/disable SqlPlus HOST command?
Date: 8 Aug 2001 16:37:57 -0700
Organization: Oracle
Lines: 38
Message-ID: <9ksigl02hnh@drn.newsguy.com>
References: <3B71A0BF.7BA90639@kochandreas.com>
NNTP-Posting-Host: p-574.newsdawg.com
X-Newsreader: Direct Read News v2.80


In article <3B71A0BF.7BA90639@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