Re: Security & deletable users

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Mon, 01 Feb 1999 10:06:17 -0800
Message-ID: <36B5ED19.B30E1412@us.oracle.com>

From memory, MDSYS and ORDSYS are created when Context is installed. I've never actually used Context, so I'm not sure what they do, but I've installed it and seen those users.

HTH Pete

Jonathan Gennick wrote:

> On Fri, 29 Jan 1999 19:02:15 GMT, John M
> <jmullee_at_hotmail.com> wrote:
>
> >Oracle NT 8.0 Quikie: Which users are installed by default,
> >and therefore should not be deleted?
> > DBSNMP ?
>
> You may be able to delete this. I always do. I think it is
> used by Enterprise Manager's intelligent agent. You should
> probably investigate this a bit more before deleting it, to
> be sure that you don't use it.
>
> > DEMO deletable ?
> yes.
>
> > MDSYS ?
> > ORDSYS ?
> I don't know what the above two are for. Could they be users
> that you created?
>
> > SCOTT deletable ?
> yes. The user SCOTT owns some demo tables.
>
> > SYS not !?!
> > SYSTEM not !?!
> Do NOT delete either of the above two users.
>
> > TONINATO deletable ?
> > JOBSITE deletable ?
>
> These probably have something to do with an application that
> you run.
>
> Jonathan

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com

WISE Course Development Manager            Phone: +1.650.607.0109
(int'l)
Worldwide Internal Services Education               (650)607 0109

(local)
San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Feb 01 1999 - 12:06:17 CST