Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem with view

Re: problem with view

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: 2000/05/09
Message-ID: <dqTR4.10581$OO6.1135908@nnrp4.clara.net>#1/1

daud11_at_hotmail.com wrote in message <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.
>>
>
>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

It's unlikely to be anything to do with permissions. If you had a permissions problem you'd get an error, not just 0 rows returned.

What is nvsys.glpn_all_balances? Is it a table or another view?

I suspect it's a view. Somewhere in this view, or in a view within it I reckon you'll find a predicate of the form:

     AND COLUMN_NAME = USER ie. the rows to be returned are dependent on who's running the query. Dig deeper.

Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.
Received on Tue May 09 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US