Re: problem with view

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: 2000/05/08
Message-ID: <8f5tco$aku$1@soap.pipex.net>#1/1

does userB have select privileges on nvsys.glpn_all_balances ?

Select with grant is not what you want.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<daud11_at_hotmail.com> wrote in message news:8f3145$gpl$1_at_nnrp1.deja.com...


>

> > 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 Mon May 08 2000 - 00:00:00 CDT