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