title: Postgres Grant SELECT & UPDATE privilege ONLY to a user
body: <p>Can anyone kindly tell me how I can grant a user (username: restricted_user) with only SELECT AND UPDATE privilege on postgresql? I'm running centos. </p>
  
  <p>At the moment the user cannot select anything. I've logged in to phpPgMyAdmin and i can only seem to grant the SELECT and UPDATE privilege per table for the user which works but I would like to apply this rule for all tables across all databases.</p>
  
  <p>thanks</p>