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.
>
>
>
> [image: 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.
>
>
>
> [image: 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






(image/jpeg attachment: image002.jpg)




(image/jpeg attachment: image004.jpg)