Giving the Database User a Password
To connect using client tools, the user must have a database password (unless using an external mechanism such as Kerberos). If not done as part of the installation, the password can be set up by connecting to iidbdb and issuing SQL commands (as below), or by using the accessdb utility. If you are new to Actian database software, it may be easier to use the accessdb utility.
As of 4.2.1, setting an initial password for the installation owner is done as part of the installation and the steps below may not be required. However if you are working with a version prior to 4.2.1, or wish to set up additional users, then refer to this section.
# Connect as the installation owner, set the environment variables, and connect to iidbdb.
su - actian
. ./.ingVHsh
sql iidbdb
TERMINAL MONITOR Copyright 2014 Actian Corporation
Actian Vector H Linux Version VH 4.1.1 (a64.lnx/158) login
Tue Jun 16 10:15:02 2015
Enter \g to execute commands, "help help\g" for general help,
"help tm\g" for terminal monitor help, \q to quit
continue
* alter user actian with password = 'actian' \g
Executing . . .
continue
* \q
Your SQL statement(s) have been committed.
Actian Vector H Version VH 4.1.1 (a64.lnx/158) logout
Tue Jun 16 10:17:05 2015
[actian@VectorH-HW1 ~]$ sql -Uactian -Pactian pocdb
TERMINAL MONITOR Copyright 2014 Actian Corporation
Actian Vector H Linux Version VH 4.1.1 (a64.lnx/158) login
Tue Jun 16 10:19:13 2015
Enter \g to execute commands, "help help\g" for general help,
"help tm\g" for terminal monitor help, \q to quit
continue
* \q
The iidbdb database is the VectorH master database (that is, the database of databases) and holds metadata for the installation. If you need to create other users, you can do so by connecting to this database.