johnsok
Member²
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;
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:
