title: Granting privileges to user on AWS RDS Insance
body: <p>I am currently importing a dump file inside RDS Oracle 12C instance using <code>impdp</code> command.</p>
  
  <p>Prior to that it is required to create few users &amp; grant them required privileges. </p>
  
  <p>I have following statements that I use on other non-rds databases.</p>
  
  <pre><code>GRANT UNLIMITED TABLESPACE TO "USERNAME"
  GRANT "RESOURCE" TO "USERNAME"
  GRANT "CONNECT" TO "USERNAME"
  GRANT "EXECUTE_CATALOG_ROLE" TO "USERNAME"
  </code></pre>
  
  <p>When I run these prior to import, these commands return <code>grant succeeded</code>.</p>
  
  <p>Now, when I run <code>impdp</code>, I get following errors in log:</p>
  
  <pre><code>Processing object type SCHEMA_EXPORT/SYSTEM_GRANT                               
  ORA-31685: Object type SYSTEM_GRANT:"USRNAME" failed due to insufficient privileges. 
  Failing sql is:  
  
  GRANT UNLIMITED TABLESPACE TO "USERNAME"
  
  ORA-39083: Object type ROLE_GRANT failed to create with error:                  
  ORA-01924: role 'CONNECT' not granted or does not exist  
  Failing sql is:   
  
  GRANT "CONNECT" TO "USERNAME"
  </code></pre>
  
  <p>Same for other privileges as well.</p>
  
  <p>I am running these commands using <code>admin</code> user that was created while spinning up the instance.</p>
  
  <p>I have seen there's a different way of granting in AWS RDS <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.System.html#Appendix.Oracle.CommonDBATasks.TransferPrivileges" rel="nofollow noreferrer">on this link</a></p>
  
  <p>How do I map that with what I'm trying to achieve here? </p>