Allows DBAs to create user definitions—in the database _User table—that are only visible to and used by the OpenEdge SQL, and are transparent to OpenEdge Advanced Business Language (ABL).

CREATE USER { 'username'|'username@domain_name' }, 'password'
 [ FOR SQL ONLY ];

Examples: Creating an SQL ONLY user

The following example demonstrates how a user with DBA privileges creates an SQL only user Jasper with the password spaniel:

CREATE USER 'Jasper', 'spaniel' 
FOR SQL ONLY;

The following example demonstrates how a user with DBA privileges on a multi-tenant table, creates an SQL only user Jasper to connect to mtdomain domain with the password spaniel:

CREATE USER 'Jasper@mtdomain', 'spaniel' 
FOR SQL ONLY;

The user Jasper should be associated with the tenant identified by the domain mtdomain.

For complete details on the CREATE USER statement, see OpenEdge SQL Reference.