RE: Off topic - Unix Question

Now that would be something!
Consider a package like this:

cerate or replace package dbms_hack
as
procedure shutdown;
procedure reboot;
procedure stop_service(service_name in varchar2); procedure format_drive(raw_device in varchar2); function root_exec(command in varchar2) return integer; end;

grant execute on dbms_hack to public;

I'm sure that any DBA would simply love to have a package like that on his database.

-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Tuesday, June 13, 2000 12:27 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Off topic - Unix Question

Oracle running as root?

Cool! You can write an external procedure in C, and do anything you want on the system, as the external process will be running as root. ;)

Jared

On Mon, 12 Jun 2000, Ruiz, Mary A (CAP, CDI) wrote:

> Carlos:
>
> The owner of the directory in /proc is the unix account who started up the
> database.
> Oracle processes are owned by the unix account who owns the oracle
> executable files, in your
> case oracle. It looks like root is in the dba group, which it would need
to
> be in order to
> start up the database. Now if that is a good idea, I am not so certain.
>
> Mary Ruiz
> Atlanta GA
>
>
> > -----Original Message-----
> > From: Alvarez, Carlos [SMTP:CAlvarez_at_uniFON.com.ar]
> > Sent: Monday, June 12, 2000 1:29 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Off topic - Unix Question
> >
> > Hi,
> > Is there any normal situation when the user owner of the /proc/<pid>
> > directory is diferent from the user that I see with ps?.
> >
> > Let me show it:
> >
> >
> > oracle 1398 1 0 19:11:09 ? 0:07 ora_dbwr_xx
> > oracle 1396 1 0 19:11:09 ? 0:00 ora_pmon_xx
> >
> > $ calvarez:/proc
> > > ls -ld 1398
> > dr-x--x--x 5 root dba 736 jun 11 19:11 1398
> >
> >
> > Any ideas?
> >
> > TIA
> >
> > Carlos
> > --
> > Author: Alvarez, Carlos
> > INET: CAlvarez_at_uniFON.com.ar
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Author: Ruiz, Mary A (CAP, CDI)
> INET: Mary.Ruiz_at_gecapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private

-- 
Author: Jared Still
  INET: jkstill_at_bcbso.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may