From 160861.1:
MDSYS, ORDSYS, CTXSYS, and ORDPLUGINS are created to support Oracle Intermedia.
Have Fun :)
Jacques Kilchoer wrote:
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:[EMAIL PROTECTED]
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: Chip INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
