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@xxxxxxxxx>:
I've tried both single and double quotes. Neither works.
On Wed, Feb 13, 2019 at 10:19 AM Testa, Joseph S <TESTAJ3@xxxxxxxxxxxxxx
<mailto:TESTAJ3@xxxxxxxxxxxxxx>> 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@xxxxxxxxx <mailto:sbecker6925@xxxxxxxxx>; oracle-l
<oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>>
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@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>> On
Behalf Of Sandra Becker
Sent: Wednesday, February 13, 2019 12:17 PM
To: oracle-l <oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>>
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.