Error -26707 when running CREATE USER command

Technote (troubleshooting)


Problem(Abstract)


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

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

Cause

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
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sec.doc/ids_am_047.htm

Surrogate user properties
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sqls.doc/ids_sqs_2290.htm

CREATE USER statement
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sqls.doc/ids_sqs_1821.htm

CREATE DEFAULT USER statement
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sqls.doc/ids_sqs_1823.htm

Private installation feature of Informix: Client perspective - the "Uses of syntaxes" section
www.ibm.com/developerworks/data/library/techarticle/dm-1211informixprivateinst/index.html

Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Servers

Software version:

11.7, 11.70, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

1641381

Modified date:

2013-06-19

Translate my page

Machine Translation

Content navigation