No I wasn't suggesting that the security people be soley responsible for screening for pissed people, but if the obvious one goes through then it could be brought to the attention of the appropriate person. Taking into account that the "pissed person" may only be seeing some body off and no risk at all. How about the bar staff, did he drink there, should they be resposnsible to report him to the airlines or just keep filling him up and wish him a good flight?
Some thing to do with cheese and holes!
I am supprised you are satisfied with the current standard of security though. If people are still boarding aircraft with knifes that are found by "cabin crew" then they are being screened well enough. At the moment they are more likely to confiscate a pair of nail clippers than a hunting knife.
If we are aware that some knifes are getting on board, what aren't we aware of. A serious threat isn't going to be caught playing with it, (his knife that is) by a flight attendant.