Home » RDBMS Server » Security » Store and retrieve a key from db wallet
Store and retrieve a key from db wallet [message #679895] Thu, 09 April 2020 20:23 Go to next message
suneeshvr
Messages: 5
Registered: May 2015
Junior Member
Hey , Is there any way I can store and retrieve value of a key( a string value) from the db wallet?
Thanks
Re: Store and retrieve a key from db wallet [message #679896 is a reply to message #679895] Fri, 10 April 2020 01:45 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
For example:
C:\Users\john>
C:\Users\john>mkstore -wrl \tmp\wallet -list
Oracle Secret Store Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:
Oracle Secret Store entries:
oracle.security.client.connect_string1
oracle.security.client.password1
oracle.security.client.username1

C:\Users\john>mkstore -wrl \tmp\wallet -viewEntry oracle.security.client.username1
Oracle Secret Store Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:
oracle.security.client.username1 = scott

C:\Users\john>mkstore -wrl \tmp\wallet -viewEntry oracle.security.client.password1
Oracle Secret Store Tool Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Copyright (c) 2004, 2019, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:
oracle.security.client.password1 = tiger

C:\Users\john>
Re: Store and retrieve a key from db wallet [message #679900 is a reply to message #679896] Fri, 10 April 2020 09:01 Go to previous message
suneeshvr
Messages: 5
Registered: May 2015
Junior Member
Thanks John .
Can we define additional parameter in the wallet ? say like
oracle.security.client.mykey = XXXXXXX
Also is there any way I can retrieve this key from my PL/SQL program ?

Thanks
Suneesh
Previous Topic: Oracle 19c Security O7 dictionary parameter de supported
Next Topic: Encryption
Goto Forum:
  


Current Time: Thu May 28 04:05:07 CDT 2020