RE: Droping System User

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Thu, 04 Oct 2001 12:51:33 -0700
Message-ID: <F001.003A26C9.20011004130521@fatcity.com>

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
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax: (707) 885-2275

Fuelspot
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Jacques Kilchoer
[mailto:Jacques.Kilchoer_at_quest.com]
Sent: Thursday, October 04, 2001
3:55 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Droping System User

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt'>> -----Original Message----- > From: Mercadante, Thomas F [<a
href="mailto:NDATFM_at_labor.state.ny.us">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.

<span

style='font-size:12.0pt'>

<span

style='font-size:10.0pt'>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.

<span

style='font-size:10.0pt'>I could also disconnect and reconnect to the database (though I did get the usual warning about Product_User_Profile being absent.)

<span

style='font-size:10.0pt'>What should I try to prove that my database is FUBAR?

<span

style='font-size:10.0pt'>SQL> connect jrk_at_sdjrk3 Entrez le mot de passe : ********

Connecté.
SQL> drop user system cascade ;

<span

style='font-size:10.0pt'>Utilisateur supprimé.

<span

style='font-size:10.0pt'>SQL> select count (*) from dba_objects ;

<span

style='font-size:10.0pt'> COUNT(*)

2942

<span

style='font-size:10.0pt'>SQL> create table t (n number) ;

<span

style='font-size:10.0pt'>Table créée.

<span

style='font-size:10.0pt'>SQL> insert into t (n) values (1) ;

<span

style='font-size:10.0pt'>1 ligne créée.

<span

style='font-size:10.0pt'>SQL> commit ;

<span

style='font-size:10.0pt'>Validation effectuée.

<span

style='font-size:10.0pt'>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 ;

<span

style='font-size:10.0pt'>USERNAME

SYS
OUTLN
DBSNMP
QUEST
JRK
A

<span

style='font-size:10.0pt'>6 ligne(s) sélectionnée(s). Received on Thu Oct 04 2001 - 14:51:33 CDT