Need to drop role with question marks in the role name

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Wed, 13 Feb 2019 10:16:41 -0700
Message-ID: <CAJzM94CgwW=+pxjpe5hUfaR5Ohy3PqK_Gz18BERV5xT0jn4rqQ_at_mail.gmail.com>

Oracle EE12c

Somehow a role got created with the name ???APP_READONLY??? and it is owned by the sys user. I've been asked to delete the role since it isn't valid, but I haven't been able to figure out how to delete it. Any ideas? Sandy

--

Sandy B.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 13 2019 - 18:16:41 CET

This message: [ Message body ]
Next message: Testa, Joseph S: "RE: Need to drop role with question marks in the role name"
Previous message: Sandra Becker: "Re: Duplicate from active database failing with ORA-19625 , ORA-27037 for archivelogs"
Next in thread: Woodward Informatics Ltd: "Aw: Need to drop role with question marks in the role name"
Reply: Woodward Informatics Ltd: "Aw: Need to drop role with question marks in the role name"
Reply: Ingrid Voigt: "Aw: Need to drop role with question marks in the role name"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message