SYBASE用户管理相关,安全检查基线配置用户部分:
解锁:
1> sp_locklogin tpdba, "unlock"
2> go
显示用户profile:
sp_displaylogin 'tpdba'
更改密码:
sp_password old_pwd,new_pwd,'loginname'
新增用户:
sp_addlogin loginname,password,defaultdb,defaultlanguage
--设置全局登录参数,最大登陆失败次数
sp_configure "maximum failed logins", 5
go
--设置用户登陆最大失败次数
sp_modifylogin "logname", @option="maxfailed_logins",@value="40"
go
sp_modifylogin "all overrides","maxfailed_logins",null,null, "3"
go
--设置密码复杂度及策略
sp_configure "check password for digit",1
sp_configure "minimum password length",8
sp_modifylogin "logname",@option="min password length",@value="8"
sp_modifylogin "all overrides","min password length",@value="2"
sp_configure "systemwide password expiration", 30
sp_modifylogin "loginname",@option="passwd expiration",@value="5"
sp_modifylogin "all overrides",@option="passwd expiration",@value="3"
sp_modifylogin "all overrides",@option="passwd expiration",@value="-1"
--设置密码永不过期
sp_modifylogin "maintain",@option="passwd expiration",@value="0"
解锁:
1> sp_locklogin tpdba, "unlock"
2> go
显示用户profile:
sp_displaylogin 'tpdba'
更改密码:
sp_password old_pwd,new_pwd,'loginname'
新增用户:
sp_addlogin loginname,password,defaultdb,defaultlanguage
--设置全局登录参数,最大登陆失败次数
sp_configure "maximum failed logins", 5
go
--设置用户登陆最大失败次数
sp_modifylogin "logname", @option="maxfailed_logins",@value="40"
go
sp_modifylogin "all overrides","maxfailed_logins",null,null, "3"
go
--设置密码复杂度及策略
sp_configure "check password for digit",1
sp_configure "minimum password length",8
sp_modifylogin "logname",@option="min password length",@value="8"
sp_modifylogin "all overrides","min password length",@value="2"
sp_configure "systemwide password expiration", 30
sp_modifylogin "loginname",@option="passwd expiration",@value="5"
sp_modifylogin "all overrides",@option="passwd expiration",@value="3"
sp_modifylogin "all overrides",@option="passwd expiration",@value="-1"
--设置密码永不过期
sp_modifylogin "maintain",@option="passwd expiration",@value="0"
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/308563/viewspace-2136315/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/308563/viewspace-2136315/