There is no need to grant HiRDB's CONNECT privilege to users. User are not registered in HiRDB's SQL_USERS dictionary table.
Be sure to specify the users' passwords when you registering users in the Directory Server. You can register users without specifying passwords, but such users will not be able to connect to HiRDB.