Setting the System Administrator Password

When you install Sybase software, Sybase creates a system administrator account called "sa," which can use any database on Adaptive Server, including master, with full privileges.

Immediately after a new installation; the initial default value for the "sa" password is NULL, allowing anyone to log in as "sa." For security purposes, make sure you assign a password to "sa" before using Adaptive Server in a production environment.
The Sybase system administrator should log in to Adaptive Server as "sa" and set a password:
$SYBASE/$SYBASE_OCS/bin/isql -Usa -P -Sserver_name
1> sp_password null, new_password
2> go
where:
  • null – is the default password.
  • new_password – is the password that you are assigning to the "sa" account.

For the greatest security, Sybase recommends that you create a password of at least six characters, with a combination of letters and numbers.