RE: Droping System User

You
know, I would have thought that if Oracle was going to give you messages in French, that you would be able to write SQL in French too, like

<SPAN

class=394310714-05102001> 
<SPAN

class=394310714-05102001>SLdI> effacement de sys.user$ où name='SYS'; 
<SPAN

class=394310714-05102001>SLdI> commettez;
<SPAN

class=394310714-05102001> 
(SQL
is "Structuré Langage d'interrogation" in French :0) )
<SPAN

class=394310714-05102001> 
<SPAN

class=394310714-05102001>g
<SPAN

class=394310714-05102001> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Jacques Kilchoer   [mailto:Jacques.Kilchoer_at_quest.com]Sent: Thursday, October 04, 2001   10:30 PMTo: Multiple recipients of list ORACLE-LSubject:   RE: Droping System User
  > -----Original Message----- >
  From: Jared.Still_at_radisys.com [<A
  href="mailto:Jared.Still_at_radisys.com">mailto:Jared.Still_at_radisys.com]   > > Dropping the SYSTEM user is
  not really all that traumatic. > <FONT   size=2>> 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.
  That's the impression I get. When I looked at the objects   owned by SYSTEM in my test database before the drop, none of them seemed   vital.
  On the other hand, dropping sys would probably be bad, but I   wasn't able to do that (insufficient privileges.) <FONT   size=2>Trying to drop sys tables like sys.user$ caused an ORA-00701.   So since I'm on a quest to wound this database, I tried   this:
  SQL> delete from sys.user$ where name = 'SYS' ;   1 ligne supprimée. SQL> commit
  ; Validation effectuée.
  So far no ill effects! Received on Fri Oct 05 2001 - 10:01:54 CDT