Changing a password

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