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
How to store password field in oracle 11g database in encrypted form?
提问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.
您可以使用主加密密钥。它在许多不应滥用用户详细信息的地方(例如信用卡号)中都实现了。