♦  To change a user password (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. Click Users & Groups.

3. In the Users & Groups list, right-click a user and then choose Properties.

4. Select This User Has A Password.

5. Complete the Password and Confirm Password fields.

6. Click Apply.

7. Click OK.

♦  To change a user password (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute a ALTER USER statement.

Example

ALTER USER M_Haneef
IDENTIFIED BY welcome;

Changing the DBA password

The default password for the DBA user for all databases is sql. You should change this password to prevent unauthorized access to your database.

♦  To change the DBA password (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. Click Users & Groups.

3. In the Users & Groups list, right-click DBA and then choose Properties.

4. Select This User Has A Password.

5. Complete the Password and Confirm Password fields.

6. Click Apply.

7. Click OK.

♦  To change the DBA password (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute a ALTER USER statement.

Example

The following command changes the password for the DBA user to welcome_DBA:

ALTER USER DBA
IDENTIFIED BY welcome_DBA;

See also

• ALTER USER statement