Sybase数据库密码“恢复"；

本文介绍了Sybase数据库密码“恢复"；的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我对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.

您可以查看哈希密码