how to set password for the DB?

[cchoi]

First I ran JBoss and tried to connect to the default DB by
...
Connection con = DriverManager.getConnection
(jdbc:hsqldb:hsql://localhost:1701);
...
Connection was established as expected.

Next, I DID set password in hsqldb-ds.xml in deploy directory but same code as above runs without throwing any exception.

How can I effectively set password so any connection require correct username-password pair?

Thanks.

[adrian.brock]

I'd ask on the hsql list.

Typically this is done using sql statements
create user
grant
etc.