Abstract: In view of the security mechanism problems existing in the merchandise management system of Kangding ethnic trade, a new SQL server mechanism is proposed and the concrete implementation methods are also put forward. Practice finds that, the new SQL server view mechanism can make up for the security deficiency found in the current merchandise management system and can even find wider application in other database management systems