[Sybase] Lock and unlock login accounts in sybase

Sybase Database User Unlock

Syntax

sp_locklogin [loginame, "{lock | unlock}"]

Parameters

loginame : 잠그거나 잠금해제할 계정의 이름
lock | unlock : 잠금 OR 잠금해제 지정 값

Examples

User Lock List 조회

isql -U<ID> -P<PASSWORD> -S<SID> -X
> sp_locklogin
> go

Locked account (s) :
name
----------------------
<user lock list>

(~ row affected)
(return status = 0)

 

User Lock 방법

> sp_locklogin <user>,"lock"
> go

Account locked.
(return status = 0)

 

User Unlock 방법

> sp_locklogin <user>,"unlock"
> go

Account unlocked.
(return status =0)

 

Notes

Notes 2512997 -  How to 'lock' and 'unlock' 'sa' login - SAP ASE for BS

 

반응형

참고 자료: https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36273_1251/html/sprocs/X98458.htm 

SyBooks Online

https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01672.1572/html/sec_admin/CIHGBIAB.htm 

SyBooks Online