我对Windows上的sybase数据库具有DBA权限.
I have DBA authority to a sybase database on Windows.
我还有一个我不知道密码的用户.
I have a another user that I don't know the password for.
我经常使用知道的应用程序,并且使用该密码自动登录该应用程序.但是,我找不到在应用程序或其dlls/files/registry/etc等位置中找到该密码的方法.
I regularly use an application that does know the password, and it uses the password to automatically login to the application. However, I can't find a way to find that password anywhere in the application or its dlls/files/registry/etc.
我显然不想更改用户密码,因为无法更新应用程序中的密码(据我所知).
I obviously don't want to just change the password of the user, as the password in the application can't be updated (that i know of).
我希望能够以该用户身份登录数据库.
I want to be able to login to the database as this user.
数据库服务器是否有任何日志记录设置,将以明文形式记录密码?或我可以用来获取密码的任何其他方法(也许通过login_procedure)? 我也可以只获取密码的哈希值(+盐).
Are there any logging settings for the database server that will log the password in plaintext? Or any other methods I can use to obtain the password (maybe via login_procedure)? I'd also be okay with just obtaining the hash for the password(+salt).
推荐答案没有SAP Sybase支持的方法以明文形式获取密码.您可以通过查询master..syslogins.passwords列来查看哈希密码.
There is no SAP Sybase supported way to get the password in plaintext. You can view the hashed password by querying master..syslogins.passwords column.
一个可能的解决方法是创建一个新用户,并将其别名为数据库内有问题的用户.
A possible workaround would be to create a new user, and alias them to user in question inside the database.
sp_addalias是用于执行类似操作的命令.
sp_addalias is the command you would use to do something like that.
您可以查看哈希密码
更多推荐
Sybase数据库密码“恢复";
发布评论