RE: Droping System User

Yes, it can be dropped, but not sys (I recall doing this on a 7.3.x database a long time ago).
Recovering it would be rather troublesome. You can add it back and establish all its privileges, roles, grants, its objects (run pupbld etc etc). Hope you have a list of such things....

Want to try it on your test db and post what you find out ? :)

Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Ahmed Gholam Hussain [SMTP:ahussain_at_gisqatar.org.qa]
> Sent: Thursday, October 04, 2001 4:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Droping System User
>
> Hi list ,
>
> Sorry for posting this strange question , but I am hopeful that I will
> get some explanation ...
>
> Question : Can we drop user SYSTEM ? How we will recover that ?( I know
> that
> nobody should do that !!!!!!! )
>
> Any response would be appreciated
>
> TIA
> Gholam
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ahmed Gholam Hussain
> INET: ahussain_at_gisqatar.org.qa
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).