Sybase Create Login and Change Password

Sybase Create database Login using Sybase Central

I will walk you through creating and changing login for Adaptive Server Enterprise 15.0. Using Sybase Central and sql commands

Let’s start by launch Sybase Central

SYB_01

Connect to Sybase database server

Expand to Logins, and then right click new—Login

SYB_02

Specify login name and password them click next

SYB_03

Select the default database for the login

SYB_04

Assign access to other databases and then click finish

SYB_05

The login account created; let’s take a look to properties

SYB_06

From General tab you can see the default database assigned to login

SYB_07

From parameters tab you can “Lock Account”, “Change Password” and “Expire Password” in addition to login policy

SYB_08  SYB_08b

You can select roles for the login from Roles (ex. Sa_role)

SYB_09

Add aliases for the login

SYB_10

 

How to change the password of other login in Sybase?

Any user with sso_role can change password of other user.

Steps for changing other user password from isql. using command

  1. Login to SYBASE ASE
  2. Check your assigned priviledge.You should have sso_role

SYB_11

SYB_12

  1. Changing Passowrd of Other User.

SYNTAX :

 sp_password  ‘your_passord’, ‘New_password_for _other_user’, ‘other_user_name’

  1. Login to SYBASE ASE.
  2. Check your assigned privilege

1> sp_activeroles

2> go

Role Name

————————————————————

 

Example:

Suppose that user, who has log in with sso role, his name is ‘ahmet’ and his password ‘ ahmet123’.  And ahmet is changing password of other user whose name is ‘ yakup’ and his new password is ‘ yakup123’.

1> sp_password ‘ahmet123′,’yakup123′,’yakup’

2> go

Password correctly set.

(return status = 0)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s