Re: problem with view

From: <daud11_at_hotmail.com>
Date: 2000/05/07
Message-ID: <8f3145$gpl$1@nnrp1.deja.com>#1/1

> I don't believe UserB needs the 'select with grant option' on MyView.
> My guess would be that userA needs to take advantage of the 'select
 with
> grant option' he was given on the tables that comprise the view and
> 'grant select' to userB on each of those tables. That's a long winded
> way of saying that userB needs select privilige on the tables in the
> view. Hope this helps.
>
> Later .....
> Patrick
>

I tried the above but did not work.

Here is the select statement i use to create the view:

select

        a$acct$product,
        acct$$desc$$product,
        acct$loc_ent,
        acct$sub_a_c,
        a$period_name,
        decode( substr(a$period_name, 1, 3),    'JAN', 1,
                                                'FEB', 2,
                                                'MAR', 3,
                                                'APR', 4,
                                                'MAY', 5,
                                                'JUN', 6,
                                                'JUL', 7,
                                                'AUG', 8,
                                                'SEP', 9,
                                                'OCT', 10,
                                                'NOV', 11,
                                                'DEC', 12,
                                                0) month_num ,
        period_net
from
        nvsys.glpn_all_balances
where
        currency_code = 'USD' and
        acct$base_a_c in

('401', '402', '405', '406', '411', '412', '415', '421', '422' , '425') and acct$loc_ent not in ('FF', 'FD') and period_net <> 0

Thanks
Daud

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun May 07 2000 - 00:00:00 CDT