The UN Security Council has adopted a resolution aimed at stemming nuclear proliferation at an historic special session chaired by US President Barack Obama.