Re: grant on view with blob

Mike Olivieri wrote:
[cut]
> MY_View:
> CREATE OR REPLACE VIEW MY_View AS
> SELECT ParentID, nvl(VSIZE(MyID),0) + nvl(VSIZE(ParentID),0) +
> nvl(DBMS_LOB.GETLENGTH(my_blob),0) AS Bytes FROM My_Table;

Looks like one must have execute on sys.dbms_lob package privilege granted, before (s)he can select data from this view. And you must have execute on sys.dbms_lob with grant option to grant select from your_view to other users.

Juhan Received on Mon Mar 27 2000 - 00:00:00 CST