RE: Droping System User

[Guy Hammond]

Title: 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

 

SLdI> effacement de sys.user$ o� name='SYS'; 

SLdI> commettez;

 

(SQL is "Structur� Langage d'interrogation" in French :0) )

 

g

 

-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 10:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Droping System User

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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.

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.)
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!