Dropping the SYSTEM user is not really all that traumatic.
In most cases it's just a DBA account that may own some pieces you'd
rather not lose, but dropping SYSTEM will not be noticed by the users
of the database.
Jared
Jacques Kilchoer
<Jacques.Kilchoer@ To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
quest.com> cc:
Sent by: Subject: RE: Droping System User
[EMAIL PROTECTED]
10/04/01 12:55 PM
Please respond to
ORACLE-L
> -----Original Message-----
> From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
>
> The best way to tell if this hurts is to create a test database for
> yourself, and try it.
>
> You may not get many experienced replies for this probably because the
> question is so far out of reality that nobody thought to try
> it. I would
> think that if anyone "accidently" did this to their own database, they
> quickly followed the command with a "Restore From Backup and Rebuild"
> command.
OK, I viewed this statement from Mr. Mercadante as a challenge, so I tried
it.
I dropped user system, and was able to do a select (*) from dba_objects, a
create table, insert into the table, and commit.
I could also disconnect and reconnect to the database (though I did get the
usual warning about Product_User_Profile being absent.)
What should I try to prove that my database is FUBAR?
SQL> connect jrk@sdjrk3
Entrez le mot de passe : ********
Connect�.
SQL> drop user system cascade ;
Utilisateur supprim�.
SQL> select count (*) from dba_objects ;
COUNT(*)
----------
2942
SQL> create table t (n number) ;
Table cr��e.
SQL> insert into t (n) values (1) ;
1 ligne cr��e.
SQL> commit ;
Validation effectu�e.
SQL> disconnect
D�connect� de Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
With the Partitioning option
JServer Release 8.1.7.1.1 - Production
SQL> connect jrk@sdjrk3
Entrez le mot de passe : ********
Erreur lors de l'acc�s � PRODUCT_USER_PROFILE
Attention : Informations du profil utilisateur du produit non charg�es!
Vous devrez peut-�tre ex�cuter PUPBLD.SQL en SYSTEM
Connect�.
SQL> select username from dba_users ;
USERNAME
------------------------------
SYS
OUTLN
DBSNMP
QUEST
JRK
A
6 ligne(s) s�lectionn�e(s).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [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).
