title: Postgresql 9.3 permission denied for schema when trying to delete a row
body: <p>I created a user group called 'common' and a user named 'application'. The script below:</p>
  
  <pre><code>CREATE ROLE common NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT;
  GRANT USAGE ON SCHEMA portal TO common;
  GRANT ALL ON ALL TABLES IN SCHEMA portal TO common;
  GRANT ALL ON ALL SEQUENCES IN SCHEMA portal TO common;
  CREATE ROLE application INHERIT LOGIN PASSWORD 'xxxxxx';
  GRANT common TO application;
  </code></pre>
  
  <p>To make sure that permissions have been applied to the user 'application', I performed the following command that returned true:</p>
  
  <p> </p>
  
  <pre><code>select has_table_privilege ('application', 'portal.noticias', 'delete')
     return: t
  select has_schema_privilege ('application', 'portal', 'usage')
     return: t
  </code></pre>
  
  <p>Using the user 'application' you can insert, update and select data in the table 'portal.noticias', however when trying to delete a record the following error occurs:</p>
  
  <pre><code>ERROR:  permission denied for schema portal
  LINE 1: SELECT 1 FROM ONLY "portal"."noticias" x WHERE "codnoticia" ...                               ^
  QUERY:  SELECT 1 FROM ONLY "portal"."noticias" x WHERE "codnoticia" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
  </code></pre>
  
  <p><strong>I do not know what I did wrong, but I appreciate any help.</strong></p>