Re: Debugging user lacks privilege or object not found

Fred Toussi <[email protected]>
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <[email protected]>
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
<[1][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.

[2]http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg
.clktrk

_______________________________________________

Hsqldb-user mailing list

[3][email protected]

[4]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 >
  [5]http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/o
  stg.clktrk
  _______________________________________________
  Hsqldb-user mailing list
  [6][email protected]
  [7]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 >

[8]http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg
.clktrk

_______________________________________________

Hsqldb-user mailing list

[9][email protected]

[10]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

References

1. mailto:[email protected]
2. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
3. mailto:[email protected]
4. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
5. http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
6. mailto:[email protected]
7. https://lists.sourceforge.net/lists/listinfo/hsqldb-user
8. http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
9. mailto:[email protected]
  10. 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.