Account Management for Sybase server

To be a user of the Sybase system, you must first have your own login account. After registering with the server with its own password, you can use some of the resources in the Sybase system, and each such login account is assigned a server-level identity suid to the system.

1. Add Login

sp_addlogin login name, password [, default database]

If you do not specify a default database, the default database for that account is the Master library.

2. Change Login Properties

◇ Change Password;

◇ Lock account;

◇ term setting;

◇ assigning roles.