Re: V6 Grant to view
From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: Thu, 5 Jan 1995 12:00:45 GMT
Message-ID: <D1xLDA.G6s_at_liverpool.ac.uk>
Date: Thu, 5 Jan 1995 12:00:45 GMT
Message-ID: <D1xLDA.G6s_at_liverpool.ac.uk>
Your problem may not go away even when synonyms created. Received following, with regard to views derived from tables owned by multiple users, from a colleague some time back. Hope it helps.
T1 is a table owned by A with SELECT granted to PUBLIC
T2 is a table owned by B
B creates a the view, V1, based on tables T1 and T2
B grants SELECT on V1 to C
C CANNOT use the view
This is because B does not own T1 - even though T1 has SELECT granted to PUBLIC. The problem can only be overcome by A granting select on T1 to B WITH GRANT OPTION. Daft but true!
D Helen Harvey Received on Thu Jan 05 1995 - 13:00:45 CET