Setting the System Administrator Password

A user account called "sa" is created for the Sybase system administrator when you install the Sybase software. A user logged in as "sa" can use any database on Adaptive Server, including master, with full privileges.

Immediately after a new installation, there is no password on the "sa" account. The initial default value for the password is NULL. In a production environment, the Sybase system administrator should always use a non-default password. The Sybase system administrator should log in to Adaptive Server as "sa" and set a password:
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.