Data filtering method and system based on user permission

The invention discloses a data filtering method and system based on user permission, and the method comprises the steps: creating a permission organization table which is used for mapping the architecture of business organization nodes with different permissions in a business system; adding a permission attribution dimension column aiming at the business data table to describe a corresponding business organization node in a permission organization table to which the permission of each row of data belongs; when a current user executes data query or modification, generating an SQL statement according to a query or modification instruction; and according to the business organization node of the current user, adding a filtering condition aiming at the permission attribution dimension column in the SQL statement, and according to the filtering condition, limiting the data to be queried or modified to be the data owned by the current user to be the data owned by the data permission, and executing the modified query