Re: With statement alias problem/10g

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 12 Aug 2005 13:34:47 GMT
Message-ID: <Xns96B042EF249A0SunnySD@68.6.19.6>

"Michael O'Shea" <michael.oshea_at_tessella.com> wrote in news:1123845701.117224.249920_at_o13g2000cwo.googlegroups.com:

> All, some Friday afternoon frustration. I have created a script to
> demonstrate a problem I am currently having and have included it inline
> below. Despite the clear error message "ORA-00942: table or view does
> not exist ", I don't understand why it is occurring. Account.orgs is a
> table.

GRANT SELECT ON ACCOUNT.ORGS TO USER2; -- Should eliminate error Received on Fri Aug 12 2005 - 08:34:47 CDT