"Is this possible to detect or prevent Brute force attack, dos attack, cross site scripting attack, sql injection attack and phishing attack with scsp policies."
Brute force attempt can be detected by IDS. You can configure repeated fail attempts.
Sql injection is supported too.
Rest I am not sure of.
Thanks
____________
Amar
SSCP