Connect to the database as a user with DBA authority.
Click Users & Groups.
In the Users & Groups list, right-click a user and then choose Properties.
Select This User Has A Password.
Complete the Password and Confirm Password fields.
Click Apply.
Click OK.
Connect to the database as a user with DBA authority.
Execute a ALTER USER statement.
ALTER USER M_Haneef IDENTIFIED BY welcome; |
The default password for the DBA user for all databases is sql. You should change this password to prevent unauthorized access to your database.
Connect to the database as a user with DBA authority.
Click Users & Groups.
In the Users & Groups list, right-click DBA and then choose Properties.
Select This User Has A Password.
Complete the Password and Confirm Password fields.
Click Apply.
Click OK.
Connect to the database as a user with DBA authority.
Execute a ALTER USER statement.
The following command changes the password for the DBA user to welcome_DBA:
ALTER USER DBA IDENTIFIED BY welcome_DBA; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |