What you are asking for is not supported at this time. It's on my
short-term todo list (meaning,
I hope to have it in the next release after 1.8.0 prod).
You can create as many users with ADMIN option as you wish (equivalent
to GRANTing DBA
role in 1.8.0), you can make as many schemas as you wish, and each ADMIN
user can create
tables in a specified schema (perhaps named with same name as the user).
However, the
object schema names will have to be specified manually or with SET
SCHEMA; and there is
no way of preventing any of the ADMIN users from creating or modifying
objects in any
schema at all (other than the INFORMATION_SCHEMA), since at this time
ADMIN/DBA
privileges are global and can't be modified.
Khanh Tran wrote:
Hi,
I ‘m developing a multiple-users application that use hsql embedded.
My purpose is for each user in my system, they must have different
table space in hsql.
But the newly created user can’t create any new table. How to make
them able to create their own table?
Thanks.
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
hsqldb-developers mailing list
hsqldb-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
