RE: Need to drop role with question marks in the role name
Date: Wed, 13 Feb 2019 17:19:14 +0000
Message-ID: <SN6PR07MB45916D9DCA3291A4DA9B906097660_at_SN6PR07MB4591.namprd07.prod.outlook.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 13 2019 - 18:19:14 CET
(image/jpeg attachment: image002.jpg)