RE: Droping System User

[Christopher Spence]

Title: RE: Droping System User

The DBA_ tables are owned by SYS.   But a lot of features such as AQ and such use objects owned by SYSTEM.   "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 3:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Droping System User   > -----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).