RE: Droping System User

Other than that pesky warning message about Product User Profile not loaded... ;)

• Kirti

> -----Original Message-----
> From: Jared.Still_at_radisys.com [SMTP:Jared.Still_at_radisys.com]
> Sent: Thursday, October 04, 2001 3:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Droping System User
>
>
>
> 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 <ORACLE-L_at_fatcity.com>
> quest.com> cc:
>
> Sent by: Subject: RE: Droping
> System User
> root_at_fatcity.com
>
>
>
>
>
> 10/04/01 12:55 PM
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> > -----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).
>
>
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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: ListGuru_at_fatcity.com (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).