| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
6 ligne(s) sélectionnée(s).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.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).Received on Thu Oct 04 2001 - 14:56:12 CDT
 |
 |