You can use Rules module to do this very easily..
The Rules module allows site administrators to define conditionally
executed actions based on occurring events (known as reactive or ECA
rules).
OR
You can use below code to redirect inside hook_user_login implementation ..
function YOURMODULENAME_user_login(&$edit, $account) {
$GLOBALS['destination'] = 'node/add/page';
}
You also need to implement hook_drupal_goto_alter to perform redirect
/**
* Implements hook_drupal_goto_alter
*/
function YOURMODULENAME_drupal_goto_alter(&$path, &$options, &$http_response_code) {
// Note that this functionality cannot be backported do 6.x as Drupal 6 does
// not call drupal_alter for drupal_goto.
// This actually may be used also by templates.
if (isset($GLOBALS['destination'])) {
$destination = $GLOBALS['destination'];
// alter drupal_goto
if (is_array($destination)) {
$path = $destination[0];
$options = array();
if (count($destination) > 1) {
$options = $destination[1];
}
}
else {
$path = $destination;
}
}
}