OraFAQ Forum: Security » Grant on BLOB

Home » RDBMS Server » Security » Grant on BLOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant on BLOB [message #274705]

Tue, 16 October 2007 22:27

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

Littlefoot
Messages: 21822
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

Report message to a moderator

Re: Grant on BLOB [message #274751 is a reply to message #274705]

Wed, 17 October 2007 01:22

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 13 03:20:57 CST 2024