RE: installed users

ctxsys - intermedia text (the old Context text cartridge) ordsys - intermedia data types for storing of audio and video data mdsys - data types for storing of spatial data

I think that in 9.0 and 9.2, by default those users are created with expired and locked logins.

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com]
>
> I've started a project to review all users in all our databases and
> remove unused/unnecessary users or at the very least restrict the
> privileges they have to the minimal ones they need. In several of the
> databases there are both ORDSYS and CTXSYS. From what I've
> been able to
> find out by running the above procedures, ORDSYS is for Intermedia. I
> could have sworn CTXSYS was the Intermedia account. So... is there a
> manual I've missed that tells me exactly which of these two I have to
> have in my databases and why?
>
> In addition, I know you have to install Spatial Option as part of an
> Oracle installation, even if you don't want to use it. Some of these
> databases also have the account MDSYS, some don't. All but one are
> 9iR2. We don't use Spatial. The two databases that have this account
> (8.1.7.4 and 9.2.0.2) both use Intermedia. Does that have something to
> do with it? I don't want to remove an account I need, but I don't want
> to leave ones I don't need in the databases.
>
> Let's not even begin to talk about the fact that just about EVERY user
> seems to have "unlimited tablespace" priv.
>
> This is not going to be pretty, easy or clean. But I will have secure
> databases. Except of course, every app has a configuration file in
> which they hard-code the passwords. Sigh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).