Problem with views

From: Valeri Ivanov <vivanov_at_annuties.ma.ee>
Date: Mon, 30 Nov 1998 13:06:48 +0200
Message-ID: <36627c2a$0$11443@diablo.uninet.ee>

Hello!

I'm using Oracle 7.3.3 for NT and
when I create view with UNION and call any functions in SELECT statements then I can't use GRANT command for this view. If I try use GRANT command then I lose
a Oracle session.

View like this:

CREATE VIEW v_sample
( field_1 ) AS
SELECT f_sample(1) FROM DUAL
UNION
SELECT f_sample(2) FROM DUAL
UNION
SELECT f_sample(3) FROM DUAL

Any ideas ?

Valeri.
vivanov_at_hireright.ee Received on Mon Nov 30 1998 - 05:06:48 CST