Forum Stats

  • 3,760,446 Users
  • 2,251,707 Discussions
  • 7,871,127 Comments

Discussions

view creation in Oracle Audit Vault Server

Hi,

My vendor has instructed me to create a view in Oracle Audit Vault Server as AVSYS user. I am able connect as under :

# su - dvaccountmgr

$ sqlplus /

My queries are :

  1. How I will connect as AVSYS user to create view? What is the default password of AVSYS user.
  2. If I change AVSYS user password , is there any impact in the existing configuration7?

Please help to solve the issue.


Regards,


Jewel

Answers

  • User_LVVI0
    User_LVVI0 Member Posts: 0 Green Ribbon

    can you explain it further more

  • haxy_habeeb
    haxy_habeeb Member Posts: 1 Blue Ribbon
    edited Oct 4, 2021 7:09AM

    AVSYS is a really powerful account in the AV Repository Database. This account is not in open state due to security reasons. However, you can use ORACLE recommended method of using dvaccountmgr UNIX account to open it, reset its password to any value of your choice from sql prompt, perform your activities (create view) and then lock it back. This will not affect the normal operations of the AV. All these are on versions 12.1, 12.2 and 20.

    Regards,

    Haksar.