Create a User
To create a user, you must have the required privilege, which is granted by default to the installation owner. You can create a user with the accessdb utility, through SQL by connecting to the iidbdb database, or through Actian Director.
To create a user with SQL
Issue this command at the command line:
sql iidbdb +U -u\$ingres
This directly accesses the system database where commands of the following form can be run to add new users:
CREATE USER myuser WITH NOPROFILE, PRIVILEGES=(CREATEDB,CHANGE_PASSWORD);\go
where myuser is the name of the user to be created.
For details, see the SQL Language Guide.