title: Oracle - insufficient privileges
body: <p>I have created this user "user1" in order to create my own tables and triggers on them, because I think it's not a great idea to create tables and triggers as SYS (I got the exception that I can't create a trigger on a specific table created by SYS).</p>
  
  <p>This "user1" has the following privileges:</p>
  
  <pre><code>create user user1 identified by password1;
  grant connect to user1 ;
  grant create session to user1 ;
  grant resource to user1 ;
  grant unlimited tablespace to user1 ;
  grant all privileges to user1 ;
  grant dba to user1 ;
  </code></pre>
  
  <p>But still, I can't connect to the database and I get a "insufficient privileges"-error when I try to login.</p>
  
  <p>Which privilege(s) is(are) missing?</p>
  
  <p>This is the output:</p>
  
  <p>It's german and means: </p>
  
  <pre><code>-user1 created
  -grant succeeded
  -connected
  -The established connection got closed with "Connected"-Script command
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/V9oUq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V9oUq.png" alt="enter image description here"></a></p>
  
  <p><strong>And when I then try to login, I get the following error:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/a39YE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a39YE.png" alt="enter image description here"></a></p>