RE: Droping System User

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 04 Oct 2001 11:38:23 -0700
Message-ID: <F001.003A247D.20011004115528@fatcity.com>

> -----Original Message-----
> From: Mercadante, Thomas F [mailto:NDATFM_at_labor.state.ny.us]
>
> 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_at_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_at_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). Received on Thu Oct 04 2001 - 13:38:23 CDT