title: grant all privileges to an user in Oracle 12c
body: <p>In Ora11g I used to grant all privileges to a user as follows.</p>
  
  <pre><code>create user xx identified by psw;
  grant create session, grant any privilege to xx;
  grant all privileges to xx;
  </code></pre>
  
  <p>But in Ora 12c when I execute grant privileges, I'm getting the below ERROR.</p>
  
  <blockquote>
    <p>Error starting at line : 2 in command - grant create session, grant
    any privilege to xx Error report - ORA-00604: error occurred at
    recursive SQL level 1 ORA-20997: "GRANT ANY PRIVILEGE" grants not
    allowed ORA-06512: at "RDSADMIN.RDSADMIN", line 79 ORA-06512: at line
    2
    00604. 00000 -  "error occurred at recursive SQL level %s"
    *Cause:    An error occurred while processing a recursive SQL statement
               (a statement applying to internal dictionary tables).
    *Action:   If the situation described in the next error on the stack
               can be corrected, do so; otherwise contact Oracle Support.</p>
  </blockquote>
  
  <p>I have tried the answer suggested in <a href="https://stackoverflow.com/questions/20114496/regarding-users-in-oracle-12c">1</a> and it does not seems work.</p>
  
  <p><a href="https://stackoverflow.com/questions/20114496/regarding-users-in-oracle-12c">1</a>. <a href="https://stackoverflow.com/questions/20114496/regarding-users-in-oracle-12c]">Regarding Users in Oracle 12c</a></p>
  
  <p>It is getting the below ERROR.</p>
  
  <blockquote>
    <p>GRANT All PRIVILEGE TO name Error report - ORA-00922: missing or
    invalid option
    00922. 00000 -  "missing or invalid option"
    *Cause:<br>
    *Action</p>
  </blockquote>
  
  <p><strong>Your help on "grant all privileges to a user in ora12c this is much appreciated.</strong></p>
  
  <p>Thanks!</p>