HELP: DBA locked out

From: Xuewen Lin <xuewen_at_engin.umich.edu>
Date: 6 Nov 1993 20:49:21 GMT
Message-ID: <2bh2khINNj2u_at_srvr1.engin.umich.edu>

Newsgroups: comp.databases.oracle

Subject: HELP: DBA locked out!
Summary: too many roles
Expires: 

Sender:
Followup-To:
Distribution: world
Organization: UMMC IMNS
Keywords:

This is really rediculous.

I created too many roles under DBA when I was not aware of the maximum(20 by default). I granted the roles to dba and ORACLE did not warn me then. So when I wanted to log back in as a DBA, ORACLE does not let me!

Now I am locked out. I cannot shut down the instance and reset the default maximum roles and I cannot drop or revoke or tear or burn the roles when I cannot log in as a dba.

I am desperate and depressed.

Liang Lin   Received on Sat Nov 06 1993 - 21:49:21 CET