How to get the content owned by the currently logged-in user?
This is how I have do it:

function MYHOOK_user_login(&amp;$edit, $account) {
    global $user;
    $nid = db_query('SELECT nid FROM {node} WHERE uid = :uid', array(':uid' =&gt; $user-&gt;uid))-&gt;fetchField();
    drupal_goto('node/' . $nid);
}