Can't insert a row ORA-01950: no privileges on tablespace
<p>Oracle 11G </p>

<p>I granted all the privileges to user </p>

<pre><code>ALTER USER CWS_APP quota unlimited on CWS_APP;
grant RESOURCE,CONNECT,UNLIMITED TABLESPACE to CWS_APP;
</code></pre>

<p>But still unable to insert a row into table:</p>

<pre><code>insert into CWS_RULES.pr4_base(pzinskey, pxcommitdatetime) values('abc',sysdate)
Error report -
SQL Error: ORA-01950: no privileges on tablespace 'CWS_RULES'
01950. 00000 -  "no privileges on tablespace '%s'"
*Cause:    User does not have privileges to allocate an extent in the
           specified tablespace.
*Action:   Grant the user the appropriate system privileges or grant the user
           space resource on the tablespace.
</code></pre>