Null passwords  Changing user defaults

Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

Logging in after lost password

If your site encounters any of these situations:

You can restart Adaptive Server with the dataserver -plogin_name parameter, which allows you to set a new password for these accounts and roles if there is no way to recover a lost password. login_name is the name of the user or the name of the role (sa_role or sso_role) whose password needs to be reset.

This allows you to set a new password for these account if there is no way to recover a lost password.

When you start with the -p parameter, Adaptive Server generates, displays, and encrypts a random password and saves it in master..syslogins and in master..syssrvroles as that account’s new password.

Sybase highly recommends that you change the password when the server restarts. For example, to reset the password for user rsmith who has sa_role:

dataserver -prsmith

To reset the password of the sso_role:

dataserver -psso_role




Copyright © 2005. Sybase Inc. All rights reserved. Changing user defaults

View this book as PDF