In this blog post, I will describe altering the Audit Vault 12.2 administrative users. In Audit Vault 12.2 the Database Vault Account Manager is configured for OS authentication.
Let me make a connection to Audit Vault server using ssh as follows:
ssh -l support avserver
X11 forwarding request failed on channel 0
Last login: Wed Apr 19 14:15:42 2023 from 10.215.11.111
Get the name of the Database Vault Account Manager user and open an OS session as that user:
[support@avs005056b3e636~]$ su –
[root@avs005056b3e636 ~]# grep -i “dv” /etc/passwd
“dvaccountmgr” is used to manage database users.
“dvowner” is used to manage database vault option.
[root@avs005056b3e636~]# su – dvaccountmgr
Connect to the database as the user and alter the user:
bash-4.1$ sqlplus /
SQL*Plus: Release 188.8.131.52.0 Production on Wed Apr 19 14:19:17 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Wed Apr 19 14:18:48 2023 +00:00
Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 – 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> ALTER USER AVADMIN ACCOUNT UNLOCK;
The same steps can be used to change the password of AVSYS , AV super auditors , AV auditors users as well.