Sybase Database Configuration

Step 1 Step 2 Step 3 Step 4 Step 5


Step 3: Create a Sybase User for the SAMPLE database

  • Create a Sybase user named WSDEMO, with a password of wsdemo1, for the SAMPLE database.
  • Using Sybase's GUI or isql command line interface, type:

    1. sp_addlogin WSDEMO, wsdemo1, SAMPLE
    2. go

    Next, add the user to the database and grant user permissions:
    1. use SAMPLE
    2. go
    3. sp_adduser WSDEMO
    4. go
    5. grant all to WSDEMO
    6. go

Please see Sybase documentation for more information on GUI or command line options.


Take Note!
  • Be sure you use all upper case letters when creating the WSDEMO user.
  • Be sure you use all lower case letters when creating the wsdemo1 password.