Steps to follow the lock/unlock sybase login
sp_locklogin used to lock/unlock an Adaptive Server account or displays a list of all locked accounts
login isql with system administrator
>sp_locklogin <username>,"lock"
>go
sp_locklogin stored procedure is used to check the locked accounts
>sp_locklogin
>go
to unlock the login
use the below command
>sp_locklogin
<login_name>,"unlock"
>go
User :
User is
used to access the database and its objects
Adding Users
Adaptive Server requires a two-step process to add a user: sp_addlogin followed by sp_adduser.
to check the database user list need to enter the below
command
use <DB_NAME>
go
sp_helpuser
go
sp_adduser stored procedure is used to add the users in the
database .
Here iam going to add SAPSR3 user in CL1 database .
