The invention discloses a universal API
data access control method and device, equipment and a storage medium, and the method comprises the steps: obtaining a
data model and a
database table corresponding to the
data model, and creating an associated universal API function according to the
data model and the
database table; configuring a table-level permission, a row-level permission and a column-level permission for the combination of the role and the data model; dynamically analyzing and applying a table-level permission, a row-level permission and a column-level permission through a universal API function of the universal API module; the
system can be seamlessly integrated with a general API and a low-code platform, complete decoupling of authority management and
business logic is realized, table-level, row-level and column-level refined
data access control can be provided at the same time, the security, flexibility and development efficiency of
data access are improved, increasingly complicated
business requirements are met, and the
system is suitable for popularization and application. According to the invention, refined, dynamic and code-free
authority control of the universal API is realized, and the speed and efficiency of the universal API
data access control method are improved.