Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem with view
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