Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Grant on view containing user-defined function?

Re: Grant on view containing user-defined function?

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 24 Dec 1998 14:06:15 GMT
Message-ID: <01be2f46$775aad00$190114c1@sister.grant.UUCP>


This is a bug, corrected in 7.3.4.
Try to create a dummy view with required name, give all grants and then issue
CREATE OR REPLACE
for the real view.
---
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

Paul Brewer <paulb_at_batelco.com.bh> wrote in article <01be25cf$de4b3000$0100007f_at_paulb>...
> Oracle 7.3.3.0.0 on SunOS.
> Then we created a view which uses the function. Again, works fine.
> However, when we try to grant select on the view, we get the 'end-of-file
> on
> communication channel' error.
Received on Thu Dec 24 1998 - 08:06:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US