Re: Debugging user lacks privilege or object not found

So in the second example if I were using a framework that hid the SQL query
I would not know from the error that it was the CUST column of the CUSTOMER
table (as opposed to the CUST column of a similar table also used in the
software routine).

That's probably what caused my lengthy delay in debugging yesterday.


On 24 September 2013 12:40, Fred Toussi <[email protected]> wrote:

>   Yes.
>
>  When a column does not exist it mentions the column name that was not
> found. For example, the customer table exists but there is no column named
> CUST
>
>  SELECT customer.cust FROM Customer
>  user lacks privilege or object not found: CUSTOMER.CUST
>
>  SELECT cust FROM Customer
>  user lacks privilege or object not found: CUST
>
>  On Tue, Sep 24, 2013, at 7:29, James Green wrote:
>
>  Does that error not [also] occur where the table exists but the column
> does not?
>
>
>  On 23 September 2013 18:17, Fred Toussi <[email protected]>wrote:
>
>    The name of the table is included. Below is the actual message when
> the table named CUSTOMERS is not found:
>
>  user lacks privilege or object not found: CUSTOMERS
>
>  Fred
>
>  On Mon, Sep 23, 2013, at 15:06, James Green wrote:
>
>   We have an entity that expands out to several others via join tables.
> We manage the schema in Liquibase.
>
>  The problem I have is that I'm getting the following error: user lacks
> privilege or object not found. The field it complains of is actually held
> in several different classes any of which might be being mapped during the
> test.
>
>  Would it be possible to include the table name in the exception error
> report please?
>
>  Thanks,
>
>  James
>
>
> ------------------------------------------------------------------------------
>  LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
>  1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> SharePoint
>  2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
> includes
>  Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
>  *_______________________________________________*
>  Hsqldb-user mailing list
>  [email protected]
>  https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
>  ------------------------------------------------------------------------------
>  October Webinars: Code for Performance
>  Free Intel webinars can help you accelerate application performance.
>  Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
>  the latest Intel processors and coprocessors. See abstracts and register >
>
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
>  *_______________________________________________*
>  Hsqldb-user mailing list
>  [email protected]
>  https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user