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

  • From: "Testa, Joseph S" <TESTAJ3@xxxxxxxxxxxxxx>
  • To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Feb 2019 17:19:14 +0000

Single quotes around it?

-------------------------------
Quit doing what is easy and do what is right.

[Joe_Testa_Color_LinkedIn-2]

Joseph Testa
Database Services Security

From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf 
Of Sandra Becker
Sent: Wednesday, February 13, 2019 12:17 PM
To: oracle-l <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.

JPEG image

Other related posts: