RE: Droping System User

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 04 Oct 2001 13:35:50 -0700
Message-ID: <F001.003A277F.20011004133025@fatcity.com>

> -----Original Message-----
> From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
>
> 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! Received on Thu Oct 04 2001 - 15:35:50 CDT