No admin rights user can create table, but can't access that table.

[GoogleCodeExporter]

Before submitting a bug, please check the FAQ:
http://www.h2database.com/html/faq.html

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. create no admin rights user.
2. connect to database by no admin rights user.
3. create table and execute query 'select * from foo';

create table foo(id int);
Update count: 0
(35 ms)

select * from foo;
オブジェクト "PUBLIC.FOO" に対する十分な権限がありません
Not enough rights for object "PUBLIC.FOO"; SQL statement:
select * from foo [90096-137] 90096/90096

What is the expected output? What do you see instead?

I think that I should be permitted all the operations to what I created.

What version of the product are you using? On what operating system, file
system, and virtual machine?

h2 1.2.137

Do you know a workaround?

grant all to that user by admin user.

How important/urgent is the problem for you?

not so important.

In your view, is this a defect or a feature request?

defect

Please provide any additional information below.

Original issue reported on code.google.com by litail...@gmail.com on 10 Jun 2010 at 7:04

[GoogleCodeExporter]

Hi,

There are other areas in the access rights system that need to be changed.

There is a feature request to improve the access rights system, it is now high 
priority: "Access rights: remember the owner of an object. Create, alter and 
drop privileges. COMMENT: allow owner of object to change it."

Regards,
Thomas

Original comment by thomas.t...@gmail.com on 12 Jun 2010 at 3:56

[GoogleCodeExporter]

This issue is tracked in the roadmap at http://h2database.com/html/roadmap.html 
- it will be implemented in the next weeks or month.

Original comment by thomas.t...@gmail.com on 28 Jun 2010 at 6:44

• Changed state: InRoadmap