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

Perhaps the role name is not what you think it is … some crazy hidden character maybe? You might be better pulling out the role name from all_objects or dba_roles (using LIKE %) and then execute immediate of a dynamically composed string to circumvent the hidden characters.

Mike

SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 13 18:51:39 2019

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining and Real Application Testing options

SQL> create role "??TEST??";

Role created.

SQL> drop role "??TEST??";

Role dropped.

—

Dr. Michael D. O’Shea, https://www.linkedin.com/in/michaeldoshea Woodward Informatics Ltd, http://www.strychnine.co.uk +44 (0)7402 851508

> Am 13.02.2019 um 18:48 schrieb Sandra Becker <sbecker6925_at_gmail.com>:
>
> I've tried both single and double quotes. Neither works.
>
> On Wed, Feb 13, 2019 at 10:19 AM Testa, Joseph S <TESTAJ3_at_nationwide.com <mailto:TESTAJ3_at_nationwide.com>> wrote:
> Sorry meant Double quotes “ “
>
>
>
> -------------------------------
>
> Quit doing what is easy and do what is right.
>
>
>
> <image002.jpg>
>
>
>
> Joseph Testa
>
> Database Services Security
>
>
>
> From: Testa, Joseph S
> Sent: Wednesday, February 13, 2019 12:19 PM
> To: sbecker6925_at_gmail.com <mailto:sbecker6925_at_gmail.com>; oracle-l <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>
> Subject: RE: [EXTERNAL] Need to drop role with question marks in the role name
>
>
>
> Single quotes around it?
>
>
>
> -------------------------------
>
> Quit doing what is easy and do what is right.
>
>
>
> <image004.jpg>
>
>
>
> Joseph Testa
>
> Database Services Security
>
>
>
> From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org>> On Behalf Of Sandra Becker
> Sent: Wednesday, February 13, 2019 12:17 PM
> To: oracle-l <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>
> Subject: [EXTERNAL] Need to drop role with question marks in the role name
>
>
>
> Nationwide Information Security Warning: This is an external email. Do not click on links or open attachments unless you trust the sender.
>
>
>
> 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.
>
>
>
> --
> Sandy B.
>

--
http://www.freelists.org/webpage/oracle-l