Re: V6 Grant to view

In article <1995Jan3.212647.8477_at_emma.ruc.dk>

           mettej_at_emma.ruc.dk "Mette Jespersen" writes:

: Granting to views on tables owned by system and others
:
: I've got problems - when I'm granting to a view, based on tables owned by
: system and another user.
:
: I've made a view based on 2 tables owned by system and 2 tables owned by
: another user. I've granted select to public on all tables, and granted ALL to
: public
: on the view. BUT I'ts only users which have been granted DBA, who can acces the
: view??? Other users can create a copy of the view, and acces it without
: problems.
:
: Is there a special restriction on system-owned tables, that I'm not aware
: of?
:

Interesting quirk that I came across in 6.0.33, it may still be the same:

    UserA owns table1
    grant select on table1 to userB;
    grant select on table1 to userC;

    UserB creates view1 on userA.table1
    grant select on view1 to userC;

    userC cannot use the view because it appears as a 'covert channel'     to table1: it works if userA issues:

    grant select on table1 to userB WITH GRANT OPTION;

HTH  

-- 
Jonathan Lewis