1 Reply Latest reply: Apr 27, 2011 5:32 PM by GokhanAtil RSS

    Alter user command failed

    feverlove
      Hello,

      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


      Thanks.
        • 1. Re: Alter user command failed
          GokhanAtil
          feverlove wrote:
          Hello,

          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


          Thanks.
          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.

          Please check if data vault is enabled:

          SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

          Read more about:

          http://download.oracle.com/docs/cd/E14472_01/doc.102/e14459/avadm_mng_security.htm

          Best Regards,

          Gokhan

          -------------------------------------------------------
          If this question is answered, please mark appropriate posts as correct/helpful and the thread as closed. Thanks