oracle 如何将密码字段以加密形式存储在oracle 11g 数据库中?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/21669892/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 02:13:42  来源:igfitidea点击:

How to store password field in oracle 11g database in encrypted form?

oracleencryptionoracle11gpasswordsoracle-sqldeveloper

提问by saurabhk

I have a table in database with this structure:

我在数据库中有一个具有这种结构的表:

Username Password Age email Address Phone Number

用户名密码年龄电子邮件地址电话号码

I want to store this table's data manually(not by an input from a program) in the data base so that i can fetch it later for further use.

我想在数据库中手动(而不是通过程序的输入)存储该表的数据,以便我以后可以获取它以供进一步使用。

I want to store the password in the database in the encrypted form so that nobody can see the password.

我想以加密形式将密码存储在数据库中,以便没有人可以看到密码。

How can i do this ?

我怎样才能做到这一点 ?

回答by Catmandu

I think you can go to the following site and check it out:-

我想你可以去以下网站看看:-

http://docs.oracle.com/cd/E18283_01/network.112/e10746/asotrans.htm

http://docs.oracle.com/cd/E18283_01/network.112/e10746/asotrans.htm

You can use Master Encryption Key.It is implemented in a lot of places where user details should not be misused such as credit card no.

您可以使用主加密密钥。它在许多不应滥用用户详细信息的地方(例如信用卡号)中都实现了。