在sybase中怎样锁定sa

tswy

如题

backwang

SA不能人工进行锁定！最多只能设置有效且安全的密码进行管理，如果只是出于测试SA被锁的后果就不能实现了！有些情况SA被锁定是由于数据库异常造成的！

chenfeng825

isql -Usa -w125
Password:
1> sp_locklogin sa,'lock'
2> go
Warning: the specified account is currently active.
Cannot lock the last remaining unlocked SSO login.
(return status = 1)
1> sp_addlogin sa_alias,'passwd'
2> go
Password correctly set.
Account unlocked.
New login created.
(return status = 0)
1> grant role sa_role,sso_role to sa_alias
2> go
1> sp_locklogin 'sa','lock'
2> go
Warning: the specified account is currently active.
Account locked.
(return status = 0)
1> exit
isql -Usa_alias -Ppasswd
1> sp_locklogin sa,'lock'
2> go
Account locked.
(return status = 0)
1>

echoaix

狠的：要谨慎啊
update syslogins set status=2 where name='sa'

backwang

也可以在平时准备一个全权限的选用用户，在SA有异常时可以使用！