'Public' views using private (individual) tables ?
Date: Fri, 14 May 93 11:24:46 GMT
Message-ID: <1993May14.112446.1991_at_daimi.aau.dk>
The scenario
SYSTEM have tables A, B, C
Users U1 and U2 each have their own tables B and C (identical in structure to SYSTEM's)
Users U3 have either a table C or a synonym C (for e.g. U1.C) or a view C (on one or more of tables SYSTEM.C, U1.C and U2.C)
Now I create a view as SYSTEM
CREATE VIEW D
AS SELECT ....
FROM A, B, C
WHERE ....
The question is: Is it possible to have all the users using VIEW D 'on their
own tables A, B and C' ?
Of course I can let the users create the view themselves, but my world is more dynamic in the sense one day U1.C migth be a real table the next a synonym or a view, and I want people who views U1.C to view what U1 views as C at any time.
If I just
GRANT SELECT ON D TO PUBLIC;
and
CREATE PUBLIC SYNONYM D FOR SYSTEM.D
all users (who doesn't specify their own D) will see what SYSTEM see in D.
Hope anyone can help (or at least understand what I am asking about :-))
Anders Harder
| Anders Harder (harder_at_daimi.aau.dk) I learn mostly from my failures... |
| Comp. Sci. Dept.| Private address: it isn't that I don't learn from my |
| Aarhus Univ. | Ydunsvej 12 successes... |
| DK-8000 Aarhus | DK-8230 Aabyhoj but I have more failures than successes!|
| Denmark | Denmark (Rune T. Kidde) |
Received on Fri May 14 1993 - 13:24:46 CEST