Below is the syntax to grant PROD user the CONNECT privilege on a database named PRODDB:
db2 => connect to PRODDB
Database Connection Information
Database server = DB2/AIX64 10.1.4
SQL authorization ID = DB2INST1
Local database alias = PRODDB
db2 => grant connect on database to user PROD
DB20000I The SQL command completed successfully.