Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Will Oracle _ever_ provide a built in SYSTEM command in PL/SQL
A copy of this was sent to bonanos_at_yahoo.com
(if that email address didn't require changing)
On Wed, 24 Feb 1999 08:59:33 GMT, you wrote:
>Hi All
>
>The one major frustration I have with Oracle is its lack of a SYSTEM command.
>Such a function is one of the basics of any language.
>
its not part of Ada as I recall. it was vendor specific if they had it at all...
its not there in cobol (afaik)
PL/I didn't have it...
many languages don't have it.
but anyway here is a potentially good reason why the database doesn't do it....
system would run with the permissions of the process in the OS. consider what system( 'rm -rf $ORACLE_HOME' ); might do since the processes run as oracle....
I'd hate that.
In 8.0 and up, you have extprocs. extprocs run with the privs of the user who starts the LISTENER (not the database). This is good since you can start the listener for the extproc service as some other NON oracle user (eg: user=nobody or something).
If you would like, i could send you the system command as an extproc for 8.0 and up.
>Any body else feel that way?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities