Retrieve Oracle password from Toad for Oracle
来源:互联网 发布:使用迅雷网络异常 编辑:程序博客网 时间:2024/05/21 18:46
http://damir-vadas.blogspot.co.uk/2013/06/retrive-oracle-password-from-toad-for.html?_sm_au_=i2VrD5qDJHHtH50L
One of the oldest feature Dell Toad has is saving login passwords. This is accomplish easy with enabling check box "Save passwords" on login screen.
- CONNECTIONS.INI
- CONNECTIONACTIONS.INI
- CONNECTIONPWDS.INI
The solution
The trick is based on another Toad for Oracle feature-get SQL for any kind of DDL action, which was performed through GUI, in this case creating db link. Here is what you have to do to retrieve scott password:- Connect in Toad as any user for which you DO NOT WANT TO RETRIEVE password (in mine case this is vadas user)
- Choose Database|Create|DB Link menu item
- Fill data as shown in the picture:
As you can see I have chosen scott user and password is automatically retrieved from saved passwords file. - Choose Show SQL as shown in the picture and you'll get pure SQL which contains password
The trick is working for every user's password. In next case I'm showing how to retrieve sys password, retrieved through scott connection.
The End
Someone might say this is security issue, but I do strongly think it is not! Mentioned file with stored passwords is encrypted with two keys:- Domain user name
- Some kind of workstation unique hash value
Keep in mind that newer releases of Toad do not use "workstation unique hash value", but only domain username as a pattern for hashing. Check and test before dropping old laptop data. For the end let me tell that if someone find storing password as a security issue regardless motioned, he/she can always disable that option and live with shorter
Hope this helps someone.
Cheers!
0 0
- Retrieve Oracle password from Toad for Oracle
- Toad for Oracle
- TOAD for Oracle
- Toad for oracle
- Toad for Oracle 使用说明
- Toad for Oracle 介绍
- Toad for Oracle 11
- Toad for oracle 快捷键
- Toad For Oracle 小技巧
- toad for oracle 自动提示
- Toad for oracle 12.1下载
- Toad for oracle 12.1下载
- 安装配置toad for oracle
- Trend Toad for Oracle in action
- Toad for Oracle 中文乱码问题
- toad for oracle(导入导出实例)
- 注册自己的Toad for oracle
- Quest.Toad.for.Oracle,Knowledge Xpert
- Golang 学习摘录(一)
- 网络字节序和主机字节序
- 【NOIP2015】总结
- 【黑马程序员】网络编程与反射
- svn忽略提交
- Retrieve Oracle password from Toad for Oracle
- Xcode7中你一定要知道的炸裂调试神技
- 微型Web框架(Ruby) Sinatra
- 股票实时数据接口 香港股市详细查询
- 【Java小项目】一个Socket连续传输多个文件
- NOIP2015总结
- 再谈给onScroll减压
- SSO单点登录和单点退出(跨顶级域名)
- The Best Way to Save/Import Toad Settings