[Hsqldb-developers] Please help to create regular users in Hsqldb

[peng p. <pen...@gm...>]

Hi,

I want to create some non-DBA users but I have many tables.

I think what I should do is:

1, first, create a role

CREATE role regular_user

2, grant priviledge to this role.

grant all on table1, table2,... to regular_user. (There is no short-cut as
grant all on all (or * ) to role_name ?)

3, create user user1 password "password1"

4, grant regular_user to user1.


I know there is a DBA role. Is there any other built-in role so that I can
use?

I just need to create some user without DBA role.

Thanks a lot!

Frank Peng.