A Sheffield pub has been successful in applying for a new licence despite previously shutting its doors after a customer walked in with a gun and threatened to “shoot the pub up”.