Aw: Need to drop role with question marks in the role name

From: Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk>
Date: Wed, 13 Feb 2019 18:23:50 +0100
Message-Id: <EEDCA85A-A6CF-4BA0-80FC-46A4DE8FDF54_at_strychnine.co.uk>



Perhaps

DROP ROLE SYS.“???APP_READONLY???“ (note the double quotes).

Mike
http://www.strychnine.co.uk <http://www.strychnine.co.uk/>

> Am 13.02.2019 um 18:16 schrieb Sandra Becker <sbecker6925_at_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:23:50 CET

Original text of this message