Home -> Mailing Lists -> Oracle-L -> Aw: Re: Need to drop role with question marks in the role name

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

From: <rogel_at_web.de>
Date: Wed, 13 Feb 2019 18:53:44 +0100
Message-ID: <trinity-b18342ca-9b9c-46ba-94cc-111cd62de37c-1550080424472_at_3c-app-webde-bs06> 












what's the output of





select dump(role) from dba_roles where role like '%APP_READONLY%';





?





 



Gesendet: Mittwoch, 13. Februar 2019 um 18:48 Uhr

Von: "Sandra Becker" <sbecker6925_at_gmail.com>

An: "Testa, Joseph S" <TESTAJ3_at_nationwide.com>

Cc: oracle-l <oracle-l_at_freelists.org>

Betreff: Re: Need to drop role with question marks in the role name





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> wrote:









Sorry meant Double quotes “ “



 





-------------------------------



Quit doing what is easy and do what is right.



 



Joe_Testa_Color_LinkedIn-2



 



Joseph Testa



Database Services Security





 







From: Testa, Joseph S

Sent: Wednesday, February 13, 2019 12:19 PM

To: sbecker6925_at_gmail.com; oracle-l <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.



 



Joe_Testa_Color_LinkedIn-2



 



Joseph Testa



Database Services Security



 



From:  oracle-l-bounce_at_freelists.org <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>

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





picture


(image/jpeg attachment: 01-part)



picture


(image/jpeg attachment: 02-part)






Received on Wed Feb 13 2019 - 18:53:44 CET












Original text of this message