Print Thread
ORA-00911 When editing a user and revoke object privileges with $ character
#52915 01/13/16 06:11 PM
Joined: Dec 2002
Posts: 43
Phoenix, Arizona USA
johnsok Offline OP
Member
OP Offline
Member
Joined: Dec 2002
Posts: 43
Phoenix, Arizona USA
When using the editing a user who has an object privilege on an object containing a dollar sign $, receive an invalid character error ORA-00911 when trying to remove (revoke) that privilege.

PLSD Version 11.0.4.1774 (32-bit)
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

edit: The proper syntax generated would need to include double-quotes around just the object name (not the schema):

revoke select, insert, update, delete on GC."BIN$J5BYX8rdDhzgVNIl5z1LOQ==$0" from MYUSER;

Last edited by johnsok; 01/13/16 06:31 PM.

Kate Johnson
Re: ORA-00911 When editing a user and revoke object privileges with $ character
johnsok #52922 01/14/16 09:55 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We'll fix it.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 14 (0.010s) Memory: 2.5041 MB (Peak: 3.0469 MB) Data Comp: Off Server Time: 2024-05-18 11:08:20 UTC
Valid HTML 5 and Valid CSS