Allows DBAs to alter user definitions—in the database _User table—such that the user is only visible to and used by the OpenEdge SQL, and is transparent to the OpenEdge ABL.

ALTER USER { 'username'|'username@domain_name' }
[ , 'old_password', 'new_password' ]|[ FOR SQL ONLY ]|
[ NOT FOR SQL ONLY ];

Examples: Altering an SQL ONLY user

The following example demonstrates how the ALTER USER statement changes Jasper to an SQL only user:

ALTER USER 'Jasper'
FOR SQL ONLY;

The following example demonstrates how the ALTER USER statement changes the SQL only user Jasper to an SQL and an ABL visible user:

ALTER USER 'Jasper@mtdomain'
NOT FOR SQL ONLY;

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

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