How To Change / Reset Password or Unlock AVSYS, AVadmin , AV Auditor, AV Super Auditor User Accounts in Oracle AVDF 12.2?

Hello,

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 –
Password:

[root@avs005056b3e636 ~]# grep -i “dv” /etc/passwd
dvaccountmgr:x:508:510::/usr/local/dvaccountmgr:/bin/bash
dvowner:x:509:511::/usr/local/dvowner:/bin/bash

“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 12.1.0.2.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

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.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.