开发者

Finding server password encryption properties

开发者 https://www.devze.com 2023-01-02 23:59 出处:网络
1> how can i find whether server is accepting encrypted password or not from C program using sybase library(encryption set by sp_configure \"net password enryption reqd\",1), to 开发者_如何学运维make

1> how can i find whether server is accepting encrypted password or not from C program using sybase library(encryption set by sp_configure "net password enryption reqd",1), to 开发者_如何学运维make sure whether i should call function ct_con_props (CS_SEC_EXTENDED_ENCRYPTION) or not


master.. sysconfigures contains one row for every configuration parm, with its default values.

master.. syscurconfigs contains one row for every configuration parm that has been set on your server, and their runtime values.

Therefore:

SELECT ISNULL(value, 0)
    FROM  master.. syscurconfigs
    WHERE comment = "net password encryption reqd"

If it is 1 then it is set, otherwise it is not (default, 0)

0

精彩评论

暂无评论...
验证码 换一张
取 消