you should have the permission to view data dictionary.I think the lcount column in user$ will give the failed login attempts