Rename Drupal core module tab titles

Drupal default user profile page shows tabs "View" & "Edit". If you want to add tab to the user profile page the original tabs could be confusing. Copy the following function to your custom module and it should rename the original tabs.

function user_menu_alter(&$items) {
  $items['user/%user/view']['title'] = 'View Profile';
  $items['user/%user_category/edit']['title'] = 'Edit Profile';
}

To remove tabs completely refer http://drupal.org/node/483324