feverlove wrote:By default, Oracle Database Vault is enabled in the Audit Vault Server. Oracle Database Vault restricts access to the data in the Audit Vault Server from any user, including users who have administrative access. For Oracle Audit Vault, Oracle Database Vault protects the Audit Vault Server by using a realm. To ensure that the data in the Audit Vault Server is protected, do not disable Oracle Database Vault.
I login to my audit vault database as "/as sysdba" and tried to unlock the user. I must have missed something because I thought SYS can do almost everything. Any ideas?
SQL> ALTER USER "AV" ACCOUNT UNLOCK;
ALTER USER "AV" ACCOUNT UNLOCK
ERROR at line 1:
ORA-01031: insufficient privileges