Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions » Managing user permissions and authorities

 

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