Re: Grant on view containing user-defined function?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 16 Dec 98 11:16:01 +0200
Message-ID: <ADHftTsK42@protasov.kiev.ua>

Hi,

Yes, it is very old Oracle bug. You should create simple view without function call, grant privileges on it and then create or replace it with your definition.

Andrew Protasov

> Oracle 7.3.3.0.0 on SunOS.
>
> We created a currency conversion function which reads our exchange rate
> table,
> and returns the amount in the base currency. Works fine.
> 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.
> Has anyone experienced this? Is this a bug?
>
> Paul Brewer
>
>
Received on Wed Dec 16 1998 - 03:16:01 CST