From Jacques.Kilchoer@quest.com Thu, 04 Oct 2001 13:35:50 -0700 From: Jacques Kilchoer Date: Thu, 04 Oct 2001 13:35:50 -0700 Subject: RE: Droping System User In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Droping System User > -----Original Message----- > From: Jared.Still@radisys.com [mailto:Jared.Still@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!