Release 10.1A: OpenEdge Data Management:
SQL Development

> ## Creating users

> Use the following syntax to employ the `CREATE USER` statement:

> Syntax
>     CREATE USER 'username', 'password' ;

> In Example 4–1, an account with `DBA` privileges creates the 'username' 'GPS' with 'password' 'star'.

> Example 4–1: CREATE USER statement
>     CREATE USER 'GPS', 'star';

> A user’s password can be changed easily by using the `ALTER USER` statement:

> Syntax
>     ALTER USER 'username', 'old_password', 'new_password';

> Example 4–2 demonstrates the use of the `ALTER USER` statement.

> Example 4–2: ALTER USER statement
>     ALTER USER 'GPS', 'star', 'star1';

> When users are created, the default DBA (the user who created the database) becomes disabled. It is important to grant DBA access to at least one user so you will have a valid DBA account. The user’s password can be easily changed using the `ALTER USER` statement.

> For complete details on the `CREATE USER` statement, see OpenEdge Data Management: SQL Reference .

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095