IBM Support

Error -26707 when running CREATE USER command

Technote (troubleshooting)


You are trying to run a CREATE USER command like this:

create user 'user99' with password 'u99paswd'
create user 'user99'


When you create a user for a non-root installation, you must use the PROPERTIES
option with the CREATE USER statement. You can exclude the PROPERTIES option in
the CREATE USER statement if the user has operating system properties on the
host computer. Also, you can exclude the PROPERTIES option if default properties
exist on the database server.

Resolving the problem

Here are links to documents you should read to learn more about adding internal users:

Creating database server users

Surrogate user properties

CREATE USER statement


Private installation feature of Informix: Client perspective - the "Uses of syntaxes" section

Document information

More support for: Informix Servers

Software version: 11.7, 11.70, 12.1

Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows

Reference #: 1641381

Modified date: 26 June 2014