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 Data Management: SQL Reference.
