Home » RDBMS Server » Security » Grant on BLOB
Grant on BLOB [message #274705] Tue, 16 October 2007 22:27 Go to next message
feroze
Messages: 144
Registered: September 2005
Location: chicago
Senior Member
Hi,

I was generating a script to grant select on objects
to a role

GRANT SELECT ON bin$nw0l6s0ce5bgraaduq5puw==$0 TO User_role;                                                     
GRANT SELECT ON bin$nw0l6s0ce5bgraaduq5puw==$0 TO User_role;      


And i get
 ERROR at line 1:
ORA-00911: invalid character


I have some BLOB and CLOB objects is that one it's referring to, And do we need to grant then on BLOB or CLOB columns.

Thanks

[Updated on: Wed, 17 October 2007 01:20] by Moderator

Report message to a moderator

Re: Grant on BLOB [message #274729 is a reply to message #274705] Wed, 17 October 2007 00:49 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You are trying to grant privileges on dropped objects (the ones that reside in the Recycle Bin). Are you sure you want to do that? Wouldn't you rather restore them first?

This kind of an object name is invalid and you can not use it as is. For example:
SQL> create table bin$asd==$0 (a number);
create table bin$asd==$0 (a number)
                    *
ERROR at line 1:
ORA-00922: missing or invalid option
Re: Grant on BLOB [message #274751 is a reply to message #274705] Wed, 17 October 2007 01:22 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And for a direct answer: enclose your table name between " when there are special characters (which should be avoided).

By the way, BIN$% objects are not BLOB but dropped objects.

In addition (that is not related to the question but...), it is really an interesting feature that you can select into a dropped table.

Regards
Michel

[Updated on: Wed, 17 October 2007 01:23]

Report message to a moderator

Previous Topic: ALL_TABLES is showing incorrect information
Next Topic: Privileges related problem
Goto Forum:
  


Current Time: Thu Mar 28 18:37:32 CDT 2024