title: DB2 : Grant all privileges to db2admin on the localhost database
body: <p>I have installed DB2 Express-C on my local machine and sample database is created for my username.
  Now, I want db2admin to access this sample database.
  I have tried below command,</p>
  
  <pre><code>connect to DATABASENAME user USER_NAME using USER_PASSWORD
  
  GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE TO USER DB2ADMIN;
  </code></pre>
  
  <p>But then too, I am unable to access the database tables using db2admin as shown below,</p>
  
  <pre><code>connect to DATABASENAME user db2admin using USER_PASSWORD
  
  list tables
  </code></pre>
  
  <p>It is displaying 0 record found. That means it is not able to access the database.</p>
  
  <p>Any help would be highly appreciated.</p>